Applies to SSAS Description Analysis Services pre-allocates a modest amount of memory at start up so that requests can be handled immediately. Additional memory is allocated as query and processing workloads increase. This performance counter gives an indication, in kilobytes (KB), of total current Analysis Services instance’s memory quota. This can also be referred to […]

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 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 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 […]

This collection of content will describe BI performance monitor counters (OS, SSAS, SSIS, SSRS) that can be encountered more or less commonly, which includes the description, steps that should be taken and additional resources that could be used for more serious troubleshooting Operating System (OS) %   A   C  D  P % % free space % processor […]

Applies to SSIS Description SSIS controls such as the Data Flow Task requires memory to temporary store buffers during package execution. This performance counter indicates the total amount of physical system memory allocated to the SSIS service process for package execution. Memory consumption by integration service can range from 2GB to 4GB depending on whether […]

Applies to SSIS Description This performance counter keeps track of total number of output rows that have been written into destination adapters. This counter will give you an indication of the overall execution progress of your data flow tasks. Because this counter tracks all rows read since the counter was started, you should expect the […]

Applies to Operating System Description Returns the paged to disk to resolve hard page faults. If the amounts are high (above 1000) this could indicate the server is running low on memory. This counter is the sum of Pages Input/sec and Pages Output/sec. Resolved by DBAs Suggested solutions Add additional memory Adjust the Max memory […]

Applies to Operating System Description Similar to Pages/sec except returns the number of read operations on the page file to resolve hard page faults. If the Pages/sec amount is higher than 1000 this could indicate the server is running low on memory. Page Input/sec and Page Reads/sec are very similar counters, Input/sec is the total […]

Applies to SSIS Description This performance counter monitors the total number of binary large object (BLOB) files in use for spooling by the data flow engine within a given time period. The value of this performance counter fluctuates as BLOB files are used and disposed. The value of this counter is usually high and could […]

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 Displays the average time / latency in seconds to perform volume disk write operations. Note 1 sec = 1,000 milliseconds. Microsoft recommends, for good performance, that I/O latency should not exceed 25 milliseconds. Resolved by DBAs Suggested solutions Add additional memory Increase the max memory allocation Upgrade storage Make sure […]

Applies to Operating System Description Displays the average time / latency in seconds to perform volume disk read operations. Note 1 sec = 1,000 milliseconds. Microsoft recommend for good performance I/O latency should not exceed 25 milliseconds. Resolved by DBAs Suggested solutions Add additional memory Increase the max memory allocation Upgrade storage Make sure partitions […]

Applies to SSAS Description This performance counter measures current total number of client connections waiting for a lock to be released by the Analysis Services engine. To get a complete list of current lock-waits then make use of Dynamic Management Views (DMVs). DMV queries are an alternative to running XML/A Discover commands. You must have […]

Applies to SSAS Description This performance counter measures current number of threads waiting for a latch due to internal server locks. These are latch requests that could not be given immediate grants and are in a wait state. The value of this counter is reset whenever the service is restarted. Resolved by DBAs, Server administrators, […]

Applies to SSAS Description This performance counter measures current total number of locked objects. Using ProcessUpdate option generates a lock on all partitions used by the cubes that include the dimension you are processing. The more partitions the cubes have, the more memory pressure they will generate during processing. Consider using a Dynamic Management View […]

Applies to SSAS Description This performance counter relates to the measurement of Analysis Services MDX calculations. It monitors the current number of total cached evaluation nodes built by MDX execution plans. Evaluation nodes are logical query plans generated by the Analysis Services Formula Engine to process query requests. Evaluation nodes can be created but not […]

Applies to SSAS Description The characteristics or properties of an Analysis Services dimension are defined by the metadata for that dimension, based on the settings of various dimension properties, and on the attributes or hierarchies that are contained by the dimension. This performance counter relates to the measurement of Analysis Services internal server memory and […]

Applies to Operating System Description Displays the total size in bytes of read operations on the volume. This counter can be used to form a baseline of storage usage. There is no rule of thumb for this counter as acceptable throughput is determined by workload and the level of storage available. If storage is utilized […]