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 Tip
I have a passion for crafting Business Intelligence Solutions for my user groups. My experience includes almost 15 years of SQL Server involvement with the last 12 years focused specifically on Business Intelligence, SharePoint, OLAP, SSRS, and Decision Support solutions. Currently, I am a Business Intelligence Architect in the healthcare industry, and I also teach database and analytics classes for Kennesaw State University, Southern New Hampshire University, and Reinhardt University. My education includes an MBA and an undergraduate in Accounting (yes I am a reformed accountant!), both from Kennesaw State University. I enjoy every day by trying to grow my faith and spend precious time with my family. I have been happily married to my wife of over 20 years, and we have two teenagers one who we home school with the help of a University Model School, Cornerstone Prep in Acworth, GA (cornerstoneprep.org). Our other child is a Construction Management major at KSU’s Southern Poly / Marietta campus. We are a soccer and Cross Country (XC) family who play, coach, and referee soccer or run for fun most every day. For several years, our family has volunteered (and played with the dogs and cats) at Etowah Valley Humane Society in Cartersville, GA.
- MSSQLTips Awards: Champion (100+tips) – 2016 | Author of the Year – 2015 | Author Contender – 2014, 2016-2021