Request for Threshold file for SSRS 2008 Performance Counters

Nov 9, 2009 at 1:29 AM

Hi,

I require a threshold file for the SSRS 2008 related performance counters. This will be really helpful for me to analyze report server activity. I understand that these threshold values requires input from the expert team.

Below is the list of the Performance Counters.

"ReportServer:Service"
\ReportServer:Service\Requests/sec 
\ReportServer:Service\Requests Total
\ReportServer:Service\Errors/sec
\ReportServer:Service\Errors Total
\ReportServer:Service\Bytes Sent/sec
\ReportServer:Service\Bytes Sent Total
\ReportServer:Service\Bytes Received/sec
\ReportServer:Service\Bytes Received Total
\ReportServer:Service\Active Connections
\ReportServer:Service\Logon Attempts/sec
\ReportServer:Service\Logon Attempts Total
\ReportServer:Service\Logon Successes/sec
\ReportServer:Service\Logon Successes Total
\ReportServer:Service\Requests Not Authorized
\ReportServer:Service\Requests Rejected
\ReportServer:Service\Requests Disconnected
\ReportServer:Service\Requests Executing
\ReportServer:Service\Memory Pressure State
\ReportServer:Service\Memory Shrink Notifications/sec
\ReportServer:Service\Memory Shrink Amount
\ReportServer:Service\Tasks Queued

## "MSRS 2008 Web Service"

\MSRS 2008 Web Service(*)\Report Requests
\MSRS 2008 Web Service(*)\Total Reports Executed
\MSRS 2008 Web Service(*)\Reports Executed/Sec
\MSRS 2008 Web Service(*)\Total Processing Failures
\MSRS 2008 Web Service(*)\Total Rejected Threads
\MSRS 2008 Web Service(*)\Active Sessions
\MSRS 2008 Web Service(*)\First Session Requests/Sec
\MSRS 2008 Web Service(*)\Next Session Requests/Sec
\MSRS 2008 Web Service(*)\Total Cache Hits
\MSRS 2008 Web Service(*)\Cache Hits/Sec
\MSRS 2008 Web Service(*)\Total Cache Misses
\MSRS 2008 Web Service(*)\Cache Misses/Sec
\MSRS 2008 Web Service(*)\Total Requests
\MSRS 2008 Web Service(*)\Requests/Sec
\MSRS 2008 Web Service(*)\Total Memory Cache Hits
\MSRS 2008 Web Service(*)\Memory Cache Hits/Sec
\MSRS 2008 Web Service(*)\Total Memory Cache Misses
\MSRS 2008 Web Service(*)\Memory Cache Miss/Sec
\MSRS 2008 Web Service(*)\Total Cache Hits (Semantic Models)
\MSRS 2008 Web Service(*)\Cache Hits/Sec (Semantic Models)
\MSRS 2008 Web Service(*)\Total Cache Misses (Semantic Models)
\MSRS 2008 Web Service(*)\Cache Misses/Sec (Semantic Models)


## "MSRS 2008 Windows Service"

\MSRS 2008 Windows Service(*)\Report Requests
\MSRS 2008 Windows Service(*)\Total Reports Executed
\MSRS 2008 Windows Service(*)\Reports Executed/Sec
\MSRS 2008 Windows Service(*)\Total Processing Failures
\MSRS 2008 Windows Service(*)\Total Rejected Threads
\MSRS 2008 Windows Service(*)\Active Sessions
\MSRS 2008 Windows Service(*)\First Session Requests/Sec
\MSRS 2008 Windows Service(*)\Next Session Requests/Sec
\MSRS 2008 Windows Service(*)\Total Cache Hits
\MSRS 2008 Windows Service(*)\Cache Hits/Sec
\MSRS 2008 Windows Service(*)\Total Cache Misses
\MSRS 2008 Windows Service(*)\Cache Misses/Sec
\MSRS 2008 Windows Service(*)\Total Requests
\MSRS 2008 Windows Service(*)\Requests/Sec
\MSRS 2008 Windows Service(*)\Total Memory Cache Hits
\MSRS 2008 Windows Service(*)\Memory Cache Hits/Sec
\MSRS 2008 Windows Service(*)\Total Memory Cache Misses
\MSRS 2008 Windows Service(*)\Memory Cache Miss/Sec
\MSRS 2008 Windows Service(*)\Total Cache Hits (Semantic Models)
\MSRS 2008 Windows Service(*)\Cache Hits/Sec (Semantic Models)
\MSRS 2008 Windows Service(*)\Total Cache Misses (Semantic Models)
\MSRS 2008 Windows Service(*)\Cache Misses/Sec (Semantic Models)
\MSRS 2008 Windows Service(*)\ReportServer:Service
\MSRS 2008 Windows Service(*)\Requests Rejected
\MSRS 2008 Windows Service(*)\Bytes Received Total
\MSRS 2008 Windows Service(*)\Active Connections
\MSRS 2008 Windows Service(*)\Requests Disconnected
\MSRS 2008 Windows Service(*)\Requests Not Authorized
\MSRS 2008 Windows Service(*)\Logon Successes/sec
\MSRS 2008 Windows Service(*)\Tasks Queued
\MSRS 2008 Windows Service(*)\Bytes Received/sec


Coordinator
Nov 10, 2009 at 5:03 AM

In PAL v1.x, you can create your own threshold file by clicking the Edit button on the threshold files. In PAL v2.0, you would need to edit the XML directly for now. There are a lot of threshold files that I need to convert to PAL v2.0. I'll put this on the "to do" list, but it might be a few months. If urgent, then reply to this and I'll see what I can do.

Nov 10, 2009 at 3:16 PM

Hi Clinth,

Thanks for the response. As you said in your demo, creating threshold files requires expertise on the product. I would like to get a standard threshold values for the above listed performance counters in a threshold file. This I am asking because I do not have sufficient expertise on the Reporting Services for me to define threshold values which could lead to false conclusions.

Can you please expedite this a liitle bit so that I can do a case study for improving report server performance. Thanks

Nov 18, 2009 at 1:54 AM

HI Clinth,

 

Any updates on the threshold file for SSRS performance counters?

 

Regards,

Arvind

Coordinator
Nov 18, 2009 at 3:09 AM

I can add the counters to a PAL v2.0 threshold file, but like you, I don't have the expertise to define thresholds for them. I will ping my team to see if anyone can provide me with thresholds on SSRS and be the Content Owner.

Jan 7, 2010 at 3:54 AM

Hi Clinth,

Any update on this? 

--Arvind

Coordinator
Jan 7, 2010 at 5:11 AM

Sorry, either no one on my team wants to take it on or no one knows the thresholds.

Coordinator
Jan 7, 2010 at 4:34 PM

I spoke to David Pless (owner of the SQL Server threshold file) and he will ask some folks on his team on this. No guarantees and this will likely take a few months to implement primarily because people work on this during their infrequent "free" time. If this is urgent and if your company has a Microsoft Premier Support contract, then contact your Microsoft Technical Account Manager (TAM) about this. The TAM can use the case as billable hours for our work.

Thank you,

May 22, 2012 at 12:26 PM

Hi Clint,

I just stumbled across this post.

Any new news regarding a SSRS threshold file? I think threshold values can be defined at a later time. It would be a good starter just to have the counters in a template file.

 

Regards

Dirk