SSRS quietly logs every report execution to the ReportServer database, and three built-in views — ExecutionLog, ExecutionLog2, and ExecutionLog3 — expose that data at increasing levels of detail. ExecutionLog3 is the most useful for performance work, breaking execution time into TimeDataRetrieval, TimeProcessing, and TimeRendering phases. Five practical SQL queries are provided to find the slowest reports, diagnose where time is spent, surface failed executions, identify peak usage hours, and check cache effectiveness. Practical tips cover log retention defaults (60 days), watching for parameter-driven outliers, combining with subscription data, and monitoring RowCount and ByteCount for unexpected usage patterns.
Table of contents
What are the ExecutionLog views?Understanding the key columnsUseful queries to get startedPractical tipsWrapping upSort: