Applies to SSAS Description Processing of dimensions and partitions and querying of partitions are handled by job operations. This performance counter measures the total number of jobs in the queue of the short parsing thread pool. CPU is underutilized when processing pool job queue length is greater than 0. This means that SSAS wants to […]

Applies to SSRS Description Every SSRS request is treated as a task. These tasks are processed within a thread. Availability of threads (or lack thereof) will determine whether a given task is immediately processed or left in the queue for a thread to become available. Therefore, this counter measures the total number of tasks awaiting […]

Applies to SSRS Description This counter monitors the number of times that activities originating from report execution and report management endpoints are retrieved from a memory cache instead of querying SQL Server. Stopping the Web Service causes this performance counter to be reset back to 0. Resolved by DBAs, Server administrators, System administrators, Web administrators […]

Applies to SSRS Description Like many windows applications, SSRS report can cache a copy of a processed report. This counter monitors the number of times that the report is retrieved from a memory cache instead of connecting to the database. Instances such as processing a scheduled subscription from a cache are tracked by this performance […]

Applies to SSRS Description This performance counter keeps track of all instances whereby a Web Service request is not successfully retrieved from a cache since the restart of the Web Service. This counter is cleared up whenever the Web Service is restarted. Resolved by DBAs, Server administrators, System administrators, Web administrators Suggested solutions Allocate more […]

Applies to SSRS Description This performance counter adds up the instances whereby a request such as subscription delivery or snapshot is not successfully rendered from a cache ever since the start of the Windows Service. This counter is cleared whenever Windows Service is restarted. Resolved by DBAs, Server administrators, System administrators, Web administrators, Report developers […]

Applies to SSAS Description This performance counter relates to the measurement of Analysis Services MDX calculations. Generally, for every request, Analysis Services makes a file a request to the operating system (OS); the OS then checks to see if the file is in the cache before retrieving it from hard disk. This performance counter monitors […]

Applies to SSAS Description This performance counter relates to the measurement of Analysis Services MDX calculations. An Analysis Services query can either use cell-by-cell calculation or block calculation (or computation). This performance counter monitors the total number of cell properties calculated. A high value for this counter usually indicates a need for query optimization. Resolved […]

Applies to SSAS Description This performance counter measures the total number of deadlocks detected since Analysis Services service was restarted. Deadlocks occur when conflicting locks are taken by two or more processes. To get a complete list of current deadlocks in your environment, consider using Dynamic Management Views (DMVs). You must have system administrator permissions […]

Applies to SSRS Description This counter monitors all reports that were successfully delivered to recipients using a scheduling mechanism such as timed and data driven subscriptions. The metric is represented by a positive numeric whole number which is usually low. The counter is reset whenever the Windows Service is restarted. Resolved by DBAs, Server administrators, […]

Applies to SSAS Description This performance counter relates to the measurement of Analysis Services storage engine queries. It monitors the total number of dimension queries that were processed since the restart of the Analysis Services instance. Preferably the source for these dimension queries should be the memory cache instead of retrieving the data from the […]

Applies to SSRS Description Interaction with the SSRS Windows Service is made possible through HyperText Transfer Protocol (HTTP) and Windows Management Instrumentation (WMI). This counter monitors all events that has occurred within the Windows Service. It is a cumulative numeric value that can be reset back to zero whenever the Windows Service is restarted. Resolved […]

Applies to SSAS Description This performance counter monitors the total number of failed client connection attempts to the Analysis Services instance since the counter was started. An increased value of this counter may indicate invalid logins. The value of this counter is reset whenever the Analysis Services service is restarted. Resolved by DBAs, Server administrators, […]

Applies to SSAS Description In a cube, measures are grouped by their underlying fact tables into measure groups. This performance counter relates to the measurement of Analysis Services storage engine queries. It monitors the total number of measure group queries that were processed since the restart of the Analysis Services instance. Resolved by DBAs, Server […]

Applies to SSRS Description This counter monitors all reports that were retrieved directly from CPU in-memory without querying SQL Server’s report cache. This method of rendering a report is very fast as it avoids unnecessary SQL Server database roundtrips. The value returned is a numeric whole number which is reset every time the Report Server […]

Applies to SSAS Description This performance counter relates to the measurement of Analysis Services storage engine queries and it measures the total rows of data sent by Analysis Services to client applications, in response to queries. The value of this counter is reset whenever the service is restarted. This should give you a better visibility […]

Applies to SSAS Description Processing a partition sends some messages back, among these the information how many rows were processed. This performance counter relates to the measurement of Analysis Services processing of data and it monitors the total number of rows that were actually written into disk in s multidimensional format. If the value of […]

Applies to SSAS Description Analysis Services Data Mining supports four types of queries; Prediction Queries, Content Queries, Drillthrough Queries, and Data Definition Queries. This performance counter monitors the total number of rows returned by data mining queries. The value of this counter is reset whenever the service is restarted. Resolved by DBAs, Network administrators Suggested […]

Applies to SSAS Description This performance counter monitors the total number of client connections to the Analysis Services instance that were successfully completed since the counter was started. By default, no one except a Server Administrator or Database Administrator has permission to query cubes in a database. Cube access by a non-administrator requires membership in […]

Applies to Operating System Description Displays the average size in bytes of read operations on the volume. This counter can be used in conjunction with Avg. Disk Sec/Read to determine the average read throughput of the volume. This counter can be used to form a baseline of storage usage. There is no rule of thumb […]

Applies to Operating System Description Returns the number of threads in the ready state on all processors. This counter needs to be divided by the number of processors on the server. If this value exceeds 10 per processor frequently and is correlated with high Processor % Usage Time further investigation is required. Resolved by DBAs […]

Applies to SSAS Description This performance counter relates to the measurement of Analysis Services storage engine queries and it measures the total bytes sent by Analysis Services to client applications, in response to queries. The value of this counter is reset whenever the service is restarted. Resolved by DBAs, Server administrators, BI developers Suggested solutions […]

Applies to SSAS Description Partition can be defined as the physical unit of storage that stores a subset of the Analysis Services database data. This performance counter relates to the measurement of Analysis Services processing of aggregations in MOLAP data files and it monitors the total amount of partitions processed. The total amount of partitions […]

Applies to SSRS Description This counter keeps track of all currently active reports that are being processed by the Report Server. The overall counter goes up and down depending on the amount of active report requests. The counter is reset upon Windows Service restart. Resolved by DBAs, Server administrators, System administrators, Web administrators, Report developers […]

Applies to SSRS Description This metric measures a current number of HyperText Transfer Protocol (HTTP) report requests that are currently being processed by the Report Server. This is a numeric value that keeps going up and down depending on the number of requests being processed. When the report request processing is complete and returned to […]