SQL Server Video on Reporting Services Trace Logs and PerfMon Counters

By:   |   Comments   |   Related: > Reporting Services Administration

Problem / Solution

In addition to the SSRS Execution Log that many SSRS developers and administrators are familiar with, SSRS includes both Trace Logs and SSRS specific Performance Monitor (PerfMon) counters.  SSRS administrators can review the SSRS trace log which contains a wealth of information including exceptions that were generated, background processing review, and logs of operations completed by the Report Manager and web service, and they can also review the SSRS http trace log which provides details about the SSRS web service's receipt of requests and its subsequent response to those requests.

PerfMon is another tool to keep your SSRS server running at its peak. PerfMon provides a method for recording and displaying twenty-one different counters which can help you determine what has been and is now occurring on your server. The counter list includes recording the number of login attempts, successful logins, SSRS website errors, and number of executing, rejected, disconnected, and total requests.

Watch the video to learn more.

Key Learning Items
  • SQL Server Reporting Services Trace Log
  • SQL Server Reporting Services Report Server HTTP Log
  • PerfMon Counters for SSRS
Read Companion Tips

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

About the author
MSSQLTips author Scott Murray Scott Murray has a passion for crafting BI Solutions with SharePoint, SSAS, OLAP and SSRS.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

get free sql tips
agree to terms