Learn more about SQL Server tools

 

Tutorials          DBA          Dev          BI          Career          Categories          Events          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Events

DBA    Dev    BI    Categories

 

SQL Server Video on Reporting Services Trace Logs and PerfMon Counters


By:   |   Read Comments   |   Related Tips: > Reporting Services Administration



 






Enter your email address to
get free SQL Server tips.

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


Last Update:






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

View all my tips


 









Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


Get free SQL tips:

*Enter Code refresh code     



Learn more about SQL Server tools