SSAS Performance Monitor Counters
Just want to share a frequently asked question about SSAS perf counters. About key counters, here is list below:
Performance Object |
Counter |
Logical Disk |
All/All |
Process |
Private Bytes – msmdsrv.exe |
MSAS:Memory |
Memory Usage Kb |
MSAS:Threads |
All |
Memory |
Cache Bytes |
Memory |
Standby Cache Normal Priority Bytes |
Memory |
Hard Page Faults/ sec |
Memory |
Page Reads/sec |
Memory |
Available Bytes |
MSAS:Proc Aggregations |
Temp File Bytes Written |
MSAS:Processing |
All Counters |
MSAS: MDX |
All Counters |
Also you can find full list of counters below:
Object |
Counter |
Description |
MSAS 2008:Cache |
Current KB |
Current memory used by the aggregation cache, in KB. |
MSAS 2008:Cache |
KB added/sec |
Rate of memory added to the cache, KB/sec. |
MSAS 2008:Cache |
Current entries |
Current number of cache entries. |
MSAS 2008:Cache |
Inserts/sec |
Rate of insertions into the cache. This is per partition per cube per database. |
MSAS 2008:Cache |
Evictions/sec |
Rate of evictions from the cache. This is per partition per cube per database. Typically due to background cleaner. |
MSAS 2008:Cache |
Total inserts |
Insertions into the cache. This is per partition per cube per database. |
MSAS 2008:Cache |
Total evictions |
Evictions from the cache. This is per partition per cube per database. Typically due to background cleaner. |
MSAS 2008:Cache |
Direct hits/sec |
Rate of cache direct hits. Queries were answered from an existing cache entry. |
MSAS 2008:Cache |
Misses/sec |
Rate of cache misses. |
MSAS 2008:Cache |
Lookups/sec |
Rate of cache lookups. |
MSAS 2008:Cache |
Total direct hits |
Total count of direct cache hits. Queries were answered from existing cache entries. |
MSAS 2008:Cache |
Total misses |
Total count of cache misses. |
MSAS 2008:Cache |
Total lookups |
Total number of lookups into the cache. |
MSAS 2008:Cache |
Direct hit ratio |
Ratio of cache direct hits to cache lookups, for the period between obtaining counter values. |
MSAS 2008:Cache |
Total filtered iterator cache hits |
Total number of cache hits that returned an indexed iterator over the filtered results |
MSAS 2008:Cache |
Total filtered iterator cache misses |
Total number of cache hits that were unable to build an indexed iterator over the filtered results and had to build a new cache with the filtered results |
MSAS 2008:Connection |
Current connections |
Current number of client connections established. |
MSAS 2008:Connection |
Requests/sec |
Rate of connection requests. These are arrivals. |
MSAS 2008:Connection |
Total requests |
Total connection requests. These are arrivals. |
MSAS 2008:Connection |
Successes/sec |
Rate of successful connection completions. |
MSAS 2008:Connection |
Total successes |
Total successful connections. |
MSAS 2008:Connection |
Failures/sec |
Rate of connection failures. |
MSAS 2008:Connection |
Total failures |
Total failed connection attempts. |
MSAS 2008:Connection |
Current user sessions |
Current number of user sessions established. |
MSAS 2008:Data Mining Model Processing |
Cases/sec |
Rate of processing cases. |
MSAS 2008:Data Mining Model Processing |
Current models processing |
Current number of models being processed |
MSAS 2008:Data Mining Prediction |
Predictions/sec |
Rate of Data Mining prediction queries |
MSAS 2008:Data Mining Prediction |
Rows/sec |
Rate of predicting rows |
MSAS 2008:Data Mining Prediction |
Concurrent DM queries |
Current number of Data Mining queries being actively worked on. |
MSAS 2008:Data Mining Prediction |
Queries/sec |
Rate of Data Mining queries |
MSAS 2008:Data Mining Prediction |
Total Queries |
Total Data Mining Queries received by the server |
MSAS 2008:Data Mining Prediction |
Total Rows |
Total Rows returned by Data Mining queries |
MSAS 2008:Data Mining Prediction |
Total Predictions |
Total Data Mining Prediction Queries received by the server |
MSAS 2008:Locks |
Current latch waits |
Current number of threads waiting for a latch. These are latch requests that could not be given immediate grants and are in a wait state. |
MSAS 2008:Locks |
Latch waits/sec |
Rate of latch requests that could not be granted immediately and had to wait before being granted. |
MSAS 2008:Locks |
Current locks |
Current number of locked objects. |
MSAS 2008:Locks |
Current lock waits |
Current number of clients waiting for a lock. |
MSAS 2008:Locks |
Lock requests/sec |
Number of lock requests per second. |
MSAS 2008:Locks |
Unlock requests/sec |
Number of unlock requests per second. |
MSAS 2008:Locks |
Lock grants/sec |
Number of lock grants per second. |
MSAS 2008:Locks |
Lock denials/sec |
Rate of lock denials. |
MSAS 2008:Locks |
Lock waits/sec |
Number of lock waits per second. These are lock requests that could not be given immediate lock grants and were put in a wait state. |
MSAS 2008:Locks |
Total deadlocks detected |
Total number of deadlocks detected. |
MSAS 2008:MDX |
Number of calculation covers |
Total number of evaluation nodes built by MDX execution plans including active and cached |
MSAS 2008:MDX |
Current number of evaluation nodes |
Current (approximate) number of evaluation nodes built by MDX execution plans including active and cached |
MSAS 2008:MDX |
Number of Storage Engine evaluation nodes |
Total number of Storage Engine evaluation nodes built by MDX execution plans |
MSAS 2008:MDX |
Number of cell-by-cell evaluation nodes |
Total number of cell-by-cell evaluation nodes built by MDX execution plans |
MSAS 2008:MDX |
Number of bulk-mode evaluation nodes |
Total number of bulk-mode evaluation nodes built by MDX execution plans |
MSAS 2008:MDX |
Number of evaluation nodes that covered a single cell |
Total number of evaluation nodes built by MDX execution plans that covered only one cell |
MSAS 2008:MDX |
Number of evaluation nodes with calculations at the same granularity |
Total number of evaluation nodes built by MDX execution plans for which the calculations were at the same granularity as the evaluation node |
MSAS 2008:MDX |
Current number of cached evaluation nodes |
Current (approximate) number of cached evaluation nodes built by MDX execution plans |
MSAS 2008:MDX |
Number of cached Storage Engine evaluation nodes |
Total number of cached Storage Engine evaluation nodes built by MDX execution plans |
MSAS 2008:MDX |
Number of cached bulk-mode evaluation nodes |
Total number of cached bulk-mode evaluation nodes built by MDX execution plans |
MSAS 2008:MDX |
Number of cached 'other' evaluation nodes |
Total number of cached evaluation nodes built by MDX execution plans that are neither Storage Engine nor Bulk-mode |
MSAS 2008:MDX |
Number of evictions of evaluation nodes |
Total number of cache evictions of evaluation nodes due to collisions |
MSAS 2008:MDX |
Number of hash index hits in the cache of evaluation nodes |
Total number of hits in the cache of evaluation nodes that were satisfied by the hash index |
MSAS 2008:MDX |
Number of cell-by-cell hits in the cache of evaluation nodes |
Total number of cell-by-cell hits in the cache of evaluation nodes |
MSAS 2008:MDX |
Number of cell-by-cell misses in the cache of evaluation nodes |
Total number of cell-by-cell misses in the cache of evaluation nodes |
MSAS 2008:MDX |
Number of subcube hits in the cache of evaluation nodes |
Total number of subcube hits in the cache of evaluation nodes |
MSAS 2008:MDX |
Number of subcube misses in the cache of evaluation nodes |
Total number of subcube misses in the cache of evaluation nodes |
MSAS 2008:MDX |
Total Sonar subcubes |
Total number of subcubes that query optimizer generated |
MSAS 2008:MDX |
Total cells calculated |
Total number of cell properties calculated |
MSAS 2008:MDX |
Total recomputes |
Total number of cells recomputed due to error |
MSAS 2008:MDX |
Total flat cache inserts |
Total number of cell values inserted into flat calculation cache |
MSAS 2008:MDX |
Total NON EMPTY |
Total number of times NON EMPTY algorithms is used |
MSAS 2008:MDX |
Total NON EMPTY for calculated members |
Total number of times NON EMPTY algorithm was looping over calculated members |
MSAS 2008:MDX |
Total NON EMPTY unoptimized |
Total number of times unoptimized NON EMPTY algorithm is used |
MSAS 2008:MDX |
Total Autoexist |
Total number of times autoexist performed |
MSAS 2008:MDX |
Total EXISTING |
Total number of times EXISTING set operator performed |
MSAS 2008:Memory |
Page Pool 64 Alloc KB |
Memory borrowed from system, in KB. This memory is given away to other parts of the server. |
MSAS 2008:Memory |
Page Pool 64 Lookaside KB |
Current memory in 64KB lookaside list, in KB. (Memory pages ready to be used.) |
MSAS 2008:Memory |
Page Pool 8 Alloc KB |
Memory borrowed from 64KB page pool, in KB. This memory is given away to other parts of the server. |
MSAS 2008:Memory |
Page Pool 8 Lookaside KB |
Current memory in 8KB lookaside list, in KB. (Memory pages ready to be used.) |
MSAS 2008:Memory |
Page Pool 1 Alloc KB |
Memory borrowed from 64KB page pool, in KB. This memory is given away to other parts of the server. |
MSAS 2008:Memory |
Page Pool 1 Lookaside KB |
Current memory in 8KB lookaside list, in KB. (Memory pages ready to be used.) |
MSAS 2008:Memory |
Cleaner Current Price |
Current price of memory, $/byte/time, normalized to 1000. |
MSAS 2008:Memory |
Cleaner Balance/sec |
Rate of balance+shrink operations. |
MSAS 2008:Memory |
Cleaner Memory shrunk KB/sec |
Rate of shrinking, in KB/sec. |
MSAS 2008:Memory |
Cleaner Memory shrinkable KB |
Amount of memory, in KB, subject to purging by the background cleaner. |
MSAS 2008:Memory |
Cleaner Memory nonshrinkable KB |
Amount of memory, in KB, not subject to purging by the background cleaner. |
MSAS 2008:Memory |
Cleaner Memory KB |
Amount of memory, in KB, known to the background cleaner. (Cleaner memory shrinkable + Cleaner memory nonshrinkable.) |
MSAS 2008:Memory |
Memory Usage KB |
Memory usage of the server process. Same as perfmon counter for Process\PrivateBytes. |
MSAS 2008:Memory |
Memory Limit Low KB |
Low memory limit, from configuration file. |
MSAS 2008:Memory |
Memory Limit High KB |
High memory limit, from configuration file. |
MSAS 2008:Memory |
AggCacheKB |
Current memory allocated to aggregation cache, in KB. |
MSAS 2008:Memory |
Quota KB |
Current memory quota, in KB. Memory quota is also known as a memory grant or memory reservation. |
MSAS 2008:Memory |
Quota Blocked |
Current number of quota requests that are blocked until other memory quotas are freed. |
MSAS 2008:Memory |
Filestore KB |
Current memory allocated to filestore (file cache), in KB. |
MSAS 2008:Memory |
Filestore Page Faults/sec |
Filestore page fault rate. |
MSAS 2008:Memory |
Filestore Reads/sec |
Filestore pages read/sec. |
MSAS 2008:Memory |
Filestore KB Reads/sec |
Filestore KB read/sec. |
MSAS 2008:Memory |
Filestore Writes/sec |
Filestore pages written/sec. The writes are asynchronous. |
MSAS 2008:Memory |
Filestore KB Write/sec |
Filestore KB written/sec. The writes are asynchronous. |
MSAS 2008:Memory |
Filestore IO Errors/sec |
Filestore IO Error rate. |
MSAS 2008:Memory |
Filestore IO Errors |
Filestore IO Errors total. |
MSAS 2008:Memory |
Filestore Clock Pages Examined/sec |
Rate of background cleaner examining pages for eviction consideration. |
MSAS 2008:Memory |
Filestore Clock Pages HaveRef/sec |
Rate of background cleaner examining pages that have a current reference count (are currently in use). |
MSAS 2008:Memory |
Filestore Clock Pages Valid/sec |
Rate of background cleaner examining pages that are valid candidates for eviction. |
MSAS 2008:Memory |
Filestore Memory Pinned KB |
Current filestore memory pinned KB. |
MSAS 2008:Memory |
In-memory Dimension Property File KB |
Current in-memory dimension property file KB. |
MSAS 2008:Memory |
In-memory Dimension Property File KB/sec |
In-memory dimension property file KB rate. |
MSAS 2008:Memory |
Potential In-memory Dimension Property File KB |
Potential in-memory dimension property file KB. |
MSAS 2008:Memory |
Dimension Property Files |
Number of dimension property files. |
MSAS 2008:Memory |
In-memory Dimension Index (Hash) File KB |
Current in-memory dimension index (hash) file KB. |
MSAS 2008:Memory |
In-memory Dimension Index (Hash) File KB/sec |
In-memory dimension index (hash) file KB rate. |
MSAS 2008:Memory |
Potential In-memory Dimension Index (Hash) File KB |
Potential in-memory dimension index (hash) file KB. |
MSAS 2008:Memory |
Dimension Index (Hash) Files |
Number of dimension index (hash) files. |
MSAS 2008:Memory |
In-memory Dimension String File KB |
Current in-memory dimension string file KB. |
MSAS 2008:Memory |
In-memory Dimension String File KB/sec |
In-memory dimension string file KB rate. |
MSAS 2008:Memory |
Potential In-memory Dimension String File KB |
Potential in-memory dimension string file KB. |
MSAS 2008:Memory |
Dimension String Files |
Number of dimension string files. |
MSAS 2008:Memory |
In-memory Map File KB |
Current in-memory map file KB. |
MSAS 2008:Memory |
In-memory Map File KB/sec |
In-memory map file KB rate. |
MSAS 2008:Memory |
Potential In-memory Map File KB |
Potential in-memory map file KB. |
MSAS 2008:Memory |
Map Files |
Number of map files. |
MSAS 2008:Memory |
In-memory Aggregation Map File KB |
Current in-memory aggregation map file KB. |
MSAS 2008:Memory |
In-memory Aggregation Map File KB/sec |
In-memory aggregation map file KB rate. |
MSAS 2008:Memory |
Potential In-memory Aggregation Map File KB |
Potential in-memory aggregation map file KB. |
MSAS 2008:Memory |
Aggregation Map Files |
Number of aggregation map files. |
MSAS 2008:Memory |
In-memory Fact Data File KB |
Current in-memory fact data file KB. |
MSAS 2008:Memory |
In-memory Fact Data File KB/sec |
In-memory fact data file KB rate. |
MSAS 2008:Memory |
Potential In-memory Fact Data File KB |
Potential in-memory fact data file KB. |
MSAS 2008:Memory |
Fact Data Files |
Number of fact data files. |
MSAS 2008:Memory |
In-memory Fact String File KB |
Current in-memory fact string file KB. |
MSAS 2008:Memory |
In-memory Fact String File KB/sec |
In-memory fact string file KB rate. |
MSAS 2008:Memory |
Potential In-memory Fact String File KB |
Potential in-memory fact string file KB. |
MSAS 2008:Memory |
Fact String Files |
Number of fact string files. |
MSAS 2008:Memory |
In-memory Fact Aggregation File KB |
Current in-memory fact aggregation file KB. |
MSAS 2008:Memory |
In-memory Fact Aggregation File KB/sec |
In-memory fact aggregation file KB rate. |
MSAS 2008:Memory |
Potential In-memory Fact Aggregation File KB |
Potential in-memory fact aggregation file KB. |
MSAS 2008:Memory |
Fact Aggregation Files |
Number of fact aggregation files. |
MSAS 2008:Memory |
In-memory Other File KB |
Current in-memory other file KB. |
MSAS 2008:Memory |
In-memory Other File KB/sec |
In-memory other file KB rate. |
MSAS 2008:Memory |
Potential In-memory Other File KB |
Potential in-memory other file KB. |
MSAS 2008:Memory |
Other Files |
Number of other files. |
MSAS 2008:Proactive Caching |
Notifications/sec |
Rate of notifications from relational database. |
MSAS 2008:Proactive Caching |
Processing Cancellations/sec |
Rate of processing cancellations caused by notifications. |
MSAS 2008:Proactive Caching |
Proactive Caching Begin/sec |
Rate of proactive caching begin. |
MSAS 2008:Proactive Caching |
Proactive Caching Completion/sec |
Rate of proactive caching completion. |
MSAS 2008:Proc Aggregations |
Current partitions |
Current number of partitions being processed. |
MSAS 2008:Proc Aggregations |
Total partitions |
Total number of partitions processed (successfully or otherwise). |
MSAS 2008:Proc Aggregations |
Memory size rows |
Size of current aggregations in memory. This count is an estimate. |
MSAS 2008:Proc Aggregations |
Memory size bytes |
Size of current aggregations in memory. This count is an estimate. |
MSAS 2008:Proc Aggregations |
Rows merged/sec |
Rate of rows merged or inserted into an aggregation. |
MSAS 2008:Proc Aggregations |
Rows created/sec |
Rate of aggregation rows created. |
MSAS 2008:Proc Aggregations |
Temp file rows written/sec |
Rate of writing rows to a temporary file. Temporary files are written when aggregations exceed memory limits. |
MSAS 2008:Proc Aggregations |
Temp file bytes written/sec |
Rate of writing bytes to a temporary file. Temporary files are written when aggregations exceed memory limits. |
MSAS 2008:Proc Indexes |
Current partitions |
Current number of partitions being processed. |
MSAS 2008:Proc Indexes |
Total partitions |
Total number of partitions processed (successfully or otherwise). |
MSAS 2008:Proc Indexes |
Rows/sec |
Rate of rows from MOLAP files used to create indexes. |
MSAS 2008:Proc Indexes |
Total rows |
Total rows from MOLAP files used to create indexes. |
MSAS 2008:Processing |
Rows read/sec |
Rate of rows read from all relational databases. |
MSAS 2008:Processing |
Total rows read |
Count of rows read from all relational databases. |
MSAS 2008:Processing |
Rows converted/sec |
Rate of rows converted during processing. |
MSAS 2008:Processing |
Total rows converted |
Count of rows converted during processing. |
MSAS 2008:Processing |
Rows written/sec |
Rate of rows written during processing. |
MSAS 2008:Processing |
Total rows written |
Count of rows written during processing. |
MSAS 2008:Storage Engine Query |
Current measure group queries |
Current number of measure group queries being actively worked on. |
MSAS 2008:Storage Engine Query |
Measure group queries/sec |
Rate of measure group queries |
MSAS 2008:Storage Engine Query |
Total measure group queries |
Total number of queries to measure group. |
MSAS 2008:Storage Engine Query |
Current dimension queries |
Current number of dimension queries being actively worked on. |
MSAS 2008:Storage Engine Query |
Dimension queries/sec |
Rate of dimension queries |
MSAS 2008:Storage Engine Query |
Total dimension queries. |
Total number of dimension queries. |
MSAS 2008:Storage Engine Query |
Queries answered/sec |
Rate of queries answered. |
MSAS 2008:Storage Engine Query |
Total queries answered |
Total number of queries answered. |
MSAS 2008:Storage Engine Query |
Bytes sent/sec |
Rate of bytes sent by server to clients, in response to queries. |
MSAS 2008:Storage Engine Query |
Total bytes sent |
Total bytes sent by server to clients, in response to queries. |
MSAS 2008:Storage Engine Query |
Rows sent/sec |
Rate of rows sent by server to clients. |
MSAS 2008:Storage Engine Query |
Total rows sent |
Total rows sent by server to clients. |
MSAS 2008:Storage Engine Query |
Queries from cache direct/sec |
Rate of queries answered from cache directly. |
MSAS 2008:Storage Engine Query |
Queries from cache filtered/sec |
Rate of queries answered by filtering existing cache entry. |
MSAS 2008:Storage Engine Query |
Queries from file/sec |
Rate of queries answered from files. |
MSAS 2008:Storage Engine Query |
Total queries from cache direct |
Total number of queries derived directly from cache. Note that this is per partition. |
MSAS 2008:Storage Engine Query |
Total queries from cache filtered |
Total queries answered by filtering existing cache entries. |
MSAS 2008:Storage Engine Query |
Total queries from file |
Total number of queries answered from files. |
MSAS 2008:Storage Engine Query |
Map reads/sec |
Number of logical read operations using the Map file. |
MSAS 2008:Storage Engine Query |
Map bytes/sec |
Bytes read from the Map file. |
MSAS 2008:Storage Engine Query |
Data reads/sec |
Number of logical read operations using the Data file. |
MSAS 2008:Storage Engine Query |
Data bytes/sec |
Bytes read from the Data file. |
MSAS 2008:Storage Engine Query |
Avg time/query |
Average time per query, in milliseconds. Response time based on queries answered since the last counter measurement. |
MSAS 2008:Storage Engine Query |
Network round trips/sec |
Rate of network round trips. This includes all client/server communication. |
MSAS 2008:Storage Engine Query |
Total network round trips |
Total network round trips. This includes all client/server communication. |
MSAS 2008:Storage Engine Query |
Flat cache lookups/sec |
Rate of flat cache lookups. This includes global, session, and query scope flat caches. |
MSAS 2008:Storage Engine Query |
Flat cache hits/sec |
Rate of flat cache hits. This includes global, session, and query scope flat caches. |
MSAS 2008:Storage Engine Query |
Calculation cache lookups/sec |
Rate of calculation cache lookups. This includes global, session, and query scope calculation caches. |
MSAS 2008:Storage Engine Query |
Calculation cache hits/sec |
Rate of calculation cache hits. This includes global, session, and query scope calculation caches. |
MSAS 2008:Storage Engine Query |
Persisted cache lookups/sec |
Rate of persisted cache lookups. Persisted caches are created by the MDX script CACHE statement. |
MSAS 2008:Storage Engine Query |
Persisted cache hits/sec |
Rate of persisted cache hits. Persisted caches are created by the MDX script CACHE statement. |
MSAS 2008:Storage Engine Query |
Dimension cache lookups/sec |
Rate of dimension cache lookups. |
MSAS 2008:Storage Engine Query |
Dimension cache hits/sec |
Rate of dimension cache hits. |
MSAS 2008:Storage Engine Query |
Measure group cache lookups/sec |
Rate of measure group cache lookups. |
MSAS 2008:Storage Engine Query |
Measure group cache hits/sec |
Rate of measure group cache hits. |
MSAS 2008:Storage Engine Query |
Aggregation lookups/sec |
Rate of aggregation lookups. |
MSAS 2008:Storage Engine Query |
Aggregation hits/sec |
Rate of aggregation hits. |
MSAS 2008:Threads |
Short parsing idle threads |
Number of idle threads in the short parsing thread pool. |
MSAS 2008:Threads |
Short parsing busy threads |
Number of busy threads in the short parsing thread pool. |
MSAS 2008:Threads |
Short parsing job queue length |
Number of jobs in the queue of the short parsing thread pool. |
MSAS 2008:Threads |
Short parsing job rate |
Rate of jobs through the short parsing thread pool. |
MSAS 2008:Threads |
Long parsing idle threads |
Number of idle threads in the long parsing thread pool. |
MSAS 2008:Threads |
Long parsing busy threads |
Number of busy threads in the long parsing thread pool. |
MSAS 2008:Threads |
Long parsing job queue length |
Number of jobs in the queue of the long parsing thread pool. |
MSAS 2008:Threads |
Long parsing job rate |
Rate of jobs through the long parsing thread pool. |
MSAS 2008:Threads |
Query pool idle threads |
Number of idle threads in the query thread pool. |
MSAS 2008:Threads |
Query pool busy threads |
Number of busy threads in the query thread pool. |
MSAS 2008:Threads |
Query pool job queue length |
Number of jobs in the queue of the query thread pool. |
MSAS 2008:Threads |
Query pool job rate |
Rate of jobs through the query thread pool. |
MSAS 2008:Threads |
Processing pool idle threads |
Number of idle threads in the processing thread pool. |
MSAS 2008:Threads |
Processing pool busy threads |
Number of busy threads in the processing thread pool. |
MSAS 2008:Threads |
Processing pool job queue length |
Number of jobs in the queue of the processing thread pool. |
MSAS 2008:Threads |
Processing pool job rate |
Rate of jobs through the processing thread pool. |