SSRS 2008R2 执行Log 查询

1.　　可以参考ExecutionLog3试图，此为系统安装Reporting Service自带的试图。

2.　　可以使用以下语句查询：

 1 SELECT els.LogEntryId,
 2        els.InstanceName,
 3        els.ReportID,
 4        cl.Name,
 5        cl.Path,
 6        cl.Description,
 7        els.UserName,
 8        els.ExecutionId,
 9        (CASE(RequestType)
10         WHEN 0 THEN 'Interactive'
11         WHEN 1 THEN 'Subscription'
12         WHEN 2 THEN 'Refresh Cache'
13             ELSE 'Unknown'
14         END) AS RequestType,
15        els.Format,
16        els.Parameters,
17        (CASE(ReportAction)
18         WHEN 1 THEN 'Render'
19         WHEN 2 THEN 'BookmarkNavigation'
20         WHEN 3 THEN 'DocumentMapNavigation'
21         WHEN 4 THEN 'DrillThrough'
22         WHEN 5 THEN 'FindString'
23         WHEN 6 THEN 'GetDocumentMap'
24         WHEN 7 THEN 'Toggle'
25         WHEN 8 THEN 'Sort'
26         WHEN 9 THEN 'Execute'
27             ELSE 'Unknown'
28         END) AS ItemAction,
29        els.TimeStart,
30        els.TimeEnd,
31        DATEDIFF( ms,els.TimeStart,els.TimeEnd ) DateDiff_Start_End,
32        els.TimeDataRetrieval,
33        els.TimeProcessing,
34        els.TimeRendering,
35        (CASE(Source)
36         WHEN 1 THEN 'Live'
37         WHEN 2 THEN 'Cache'
38         WHEN 3 THEN 'Snapshot'
39         WHEN 4 THEN 'History'
40         WHEN 5 THEN 'AdHoc'
41         WHEN 6 THEN 'Session'
42         WHEN 7 THEN 'Rdce'
43             ELSE 'Unknown'
44         END) AS Source,
45        els.Status,
46        els.ByteCount,
47        els."RowCount"
48   FROM dbo.ExecutionLogStorage els WITH ( NOLOCK )
49        LEFT JOIN dbo.Catalog cl WITH ( NOLOCK ) ON els.ReportID = cl.ItemID;

参考资源：

报告服务器执行日志和 ExecutionLog3 视图:

https://msdn.microsoft.com/zh-cn/subscriptions/downloads/ms159110.aspx#bkmk_executionlog2

Report Server Execution Log and the ExecutionLog3 view

https://msdn.microsoft.com/en-us/library/ms159110(v=sql.105).aspx#bkmk_executionlog3

SQL Server Report Server 2008 R2 Execution Log Reports

http://www.mssqltips.com/sqlservertip/2722/sql-server-report-server-2008-r2-execution-log-reports/

Solving issue with first long starting report on SSRS 2008

http://www.pawlowski.cz/2011/07/solving-issue-long-starting-report-ssrs-2008/

MSDN - Reporting Services (SSRS)

https://msdn.microsoft.com/zh-cn/library/ms159106.aspx