Databases Reference
In-Depth Information
Performance Counter
Counter Description
Total Cache Misses
The total number of times that requests could not be
returned from the Report Server catalog. Like other
“Total” counts, this one is reset when the service
restarts. This one can help determine if you've got
enough memory and hard drive capacity.
RS Windows Service
Delivers/Sec
Number of report deliveries per second, regardless of
the delivery method.
Cache Hits/Sec (Semantic Model)
Number of times per second for cached models.
Total App Domain Recycles
Total number of times the application domain has
been recycled.
Total Deliveries
Total number of deliveries that have been made.
Total Reports Executed
The total number of reports that have been processed.
Total Requests
Total number of incoming requests that have been
processed; there are typically more requests than
processed reports.
Another component of Reporting Services, the Report Manager, does not have its own performance
counters. The Report Manager is an ASP.NET web application that works with the report server by send-
ing requests to the Report Server Web Service. Microsoft provides two key performance objects:
ASP.NET and ASP.NET Applications. These two objects expose performance counters like Request Wait
Time and Requests Queued, which can help narrow down where a bottleneck might be.
Note that the Reporting Services Web service is also an ASP.NET application, so those monitors can help
keep an eye on it as well. Other system monitors that can provide valuable insight into how your server
environment is handling its workload include:
❑
.NET CLR Data
❑
.NET CLR Memory
❑
Memory
❑
System
The .NET CLR counters read the Common Language Runtime (CLR) of the .NET Framework. The CLR
is essentially the runtime engine that manages the applications running on the .NET Framework. This
includes providing services such as garbage collection, security checking, and application isolation.
For insight into how SQL Server is handling its side of things, use a combination of perfmon and SQL
Server Profiler to monitor the Reporting Services catalog and the data source databases. You'll want to
include both the Report Server catalog and the data source databases, which could easily be on different
machines.
Search WWH ::
Custom Search