Know more about the Report Server Settings, Report Server Service Trace Log

Posted: May 23, 2013 in SSRS, Trace Log
Tags: ,

Know more about following in Microsoft Report Server using

  • System information, including operating system, version, number of processors, and memory.
  • Reporting Services component and version information.
  • Events logged the Application log.
  • Exceptions generated by the report server.
  • Low resource warnings logged by a report server.
  • Inbound SOAP envelopes and summarized outbound SOAP envelopes.
  • HTTP header, stack trace, and debug trace information
Use the Report Log Viewer tool to get more information on the reporting service trace log and reporting service execution log …
Run the executable ReportViewer.exe from C:\Program Files (x86)\Microsoft\Reporting Services folder and select the log files location (C:\Program Files\Microsoft SQL Server\MSRS11.<instance name>\Reporting Services\LogFiles) and select one of following 3 views to analyze the data.
Trace Log Histogram – Shows the histogram view of event and number of times it occured. This view should help us pinpoint bottleneck areas if we look for spikes in certain events
Raw – Provides more information on bottleneck events because it has the “Time” component built-in
Threads – Find resource contention thru threads to get to know where the waits occur

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s