Applies to SSAS Description This performance counter relates to the measurement of Analysis Services storage engine queries. It measures the total number of queries derived directly from a memory cache since Analysis Services service was restarted. This is measured per partition. Resolved by DBAs, Server administrators, BI developers Suggested solutions Optimize the data types of […]

Applies to SSAS Description Analysis Services is a file-based database engine. It reads data from different files, makes the joins, and services the requests. This performance counter measures the total number of queries that were answered from files since the restart of the Analysis Services instance. Resolved by DBAs, Server administrators, BI developers Suggested solutions […]

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 data mining queries received by the server. If this number does not increase, then no queries are being run against the server. Resolved by […]

Applies to SSAS Description This performance counter monitors the total number of active user sessions currently connected to the Analysis Services instance. A connection is always tied to a session but there could be sessions without active user connections. It is also possible for an application to create multiple sessions over the same connection. Resolved […]

Applies to SSRS Description This performance counter monitors the total number of reports successfully generated using Web Service endpoints ever since the restart of the service. Likewise, the counter can be reset by restarting the service. Resolved by DBAs, Server administrators, System administrators, Web administrators, Report developers Suggested solutions Check the Reporting Services error log […]

Applies to SSRS Description This performance counter monitors all reports executed and successfully delivered using Windows Service features such as snapshots and subscriptions since the Windows Service was started. This cumulative counter can be reset by restarting the Windows Service. Resolved by DBAs, Web administrators, Report developers Suggested solutions Check the Reporting Services error log […]

Applies to SSRS Description This counter is similar to Total Reports Executed performance counter except that it monitors all requests regardless of whether they were successful or not since the service restart. The value of this performance counter is reset whenever Report Server Web Service is stopped by ASP.NET. Resolved by DBAs, Server administrators, System […]

Applies to SSRS Description This counter works similar to Total Reports Executed except that it monitors all requests regardless of whether they were successful or not since the Windows Service was restarted. It is reset upon the restart of the Windows Service. Resolved by DBAs, Server administrators, System administrators, Web administrators, Report developers Suggested solutions […]

Applies to SSAS Description This performance counter relates to the measurement of Analysis Services processing of indexes for MOLAP data files and it measures the total number of rows from MOLAP files used to create indexes. The value of this counter is reset whenever the service is restarted. Resolved by DBAs, Network administrators Suggested solutions […]

Applies to SSAS Description This performance counter relates to the measurement of Analysis Services processing of data and it monitors the total number of rows that were converted from a relational source into a multidimensional format during data processing. The value of this counter can be used to evaluate whether the amount of time taken […]

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 read from source into a partition when it was processed. Resolved […]

Applies to SSIS Description This performance counter monitors the total number of bytes within the data flow engine that are written out as binary large object (BLOB) into all target data sources. This is usually represented as a high bytes value which is reset back to zero bytes whenever the Integration Service server is restarted. […]

Applies to SSIS Description This performance counter measures the total number of physical or virtual memory currently being used by all SSIS packages and can be compared with the amount of available system memory to know if Integration Services processing is bottlenecked by the available RAM. The recommended value for this counter is the one […]

Applies to SSIS Description When Integration Services runs out physical or virtual memory during process/package execution, it will begin spooling buffers to hard disk. This performance counter measures the total number whereby spooling of buffers to hard disk was done by Integration Services service. An increase in value of this counter may indicate that you […]

Applies to SSRS Description This performance counter indicates as to how much bytes have been sent by the Report Server back to the client application. The value of this counter only gets changed when the HTTP requests have been completed. The value of this performance counter is measured in bytes and is usually high. The […]

Applies to SSRS Description HyperText Transfer Protocol (HTTP) activity can be measured in terms of raw bytes used to complete a send and receive request. This performance counter indicates as to how much bytes have been received by the Report Server. The value of this counter only gets changed when the HTTP request has been […]

Applies to SSIS Description Some of the biggest transactions in SSIS takes place in the data flow tasks involving the data flow engine. This performance counter monitors the total number of bytes of binary large object (BLOB) data the data flow engine has read from all data sources. The BLOB data not only refer to […]

Applies to SSRS Description Windows Service has more features than the Web Service. For instance, features such as subscription, delivery and snapshots are all processed using Windows Service. This counter keeps tracks of all Active Sessions relating to these features. Not surprisingly, this counter is likely to have higher values than Web Service Active Sessions […]

Applies to SSRS Description This counter measures the number of successful logon attempts authenticated using RSWindowsNegotiate, RSWindowsNTLM, RSWindowsKerberos, and RSWindowsBasic authentication types. When custom authentication is used in SSRS to handle additional authentication schemes then the value of the counter will always be set to zero. Another reason for having the counter value set to […]

Applies to SSIS Description This performance counter measures the actual amount of physical memory currently allocated to the integration services. This memory block cannot be shared with any other processes. The value of this performance counter is measured in bytes and is usually high. The value is reset back to zero whenever the integration server […]

Applies to SSRS Description This is a cumulative number of all the requests that were sent to Report Manager and received by Report Server ever since the Report Server was restarted. It is represented as a numeric value that is reset every time the Report Server is restarted. Resolved by DBAs, Server administrators, System administrators, […]

Applies to SSIS Description The data flow engine is largely about the transfer of rows from source to destination. This performance counter keeps track of total number of input rows that have been read from source adapters excluding reference sources such as the Lookup transformation. Because this counter tracks all rows read since the restart […]

Applies to SSAS Description When Analysis Services memory utilization crosses the configured Low-limit, a process known as the “cleaner” is woken up and starts “evicting” older/lesser used objects out of memory on a periodic basis to make room for new objects. This performance counter measures the total amount of memory freed from cache since start […]

Applies to SSAS Description This performance counter relates to the measurement of Analysis Services MDX calculations. This performance counter monitors the total number of times an EXISTING MDX set operation was performed. By default, sets are evaluated within the context of the cube that contains the members of the set, however, the EXISTING operator forces […]

Applies to SSAS Description This performance counter relates to statistics related to the Analysis Services aggregation cache and it measures the total number of insertions into the cache per partition per cube per Analysis Services database. The value of this counter is usually high and is reset whenever the Analysis Services is restarted. Resolved by […]