Analysis Services 2008 performance counters

Here is the list of Microsoft SQL Server Analysis Services 2008 Performance counters:

Object

Counter

Description

MSAS 2008:CacheCurrent KBCurrent memory used by the aggregation cache, in KB.
MSAS 2008:CacheKB added/secRate of memory added to the cache, KB/sec.
MSAS 2008:CacheCurrent entriesCurrent number of cache entries.
MSAS 2008:CacheInserts/secRate of insertions into the cache. This is per partition per cube per database.
MSAS 2008:CacheEvictions/secRate of evictions from the cache. This is per partition per cube per database. Typically due to background cleaner.
MSAS 2008:CacheTotal insertsInsertions into the cache. This is per partition per cube per database.
MSAS 2008:CacheTotal evictionsEvictions from the cache. This is per partition per cube per database. Typically due to background cleaner.
MSAS 2008:CacheDirect hits/secRate of cache direct hits. Queries were answered from an existing cache entry.
MSAS 2008:CacheMisses/secRate of cache misses.
MSAS 2008:CacheLookups/secRate of cache lookups.
MSAS 2008:CacheTotal direct hitsTotal count of direct cache hits. Queries were answered from existing cache entries.
MSAS 2008:CacheTotal missesTotal count of cache misses.
MSAS 2008:CacheTotal lookupsTotal number of lookups into the cache.
MSAS 2008:CacheDirect hit ratioRatio of cache direct hits to cache lookups, for the period between obtaining counter values.
MSAS 2008:CacheTotal filtered iterator cache hitsTotal number of cache hits that returned an indexed iterator over the filtered results
MSAS 2008:CacheTotal filtered iterator cache missesTotal 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:ConnectionCurrent connectionsCurrent number of client connections established.
MSAS 2008:ConnectionRequests/secRate of connection requests. These are arrivals.
MSAS 2008:ConnectionTotal requestsTotal connection requests. These are arrivals.
MSAS 2008:ConnectionSuccesses/secRate of successful connection completions.
MSAS 2008:ConnectionTotal successesTotal successful connections.
MSAS 2008:ConnectionFailures/secRate of connection failures.
MSAS 2008:ConnectionTotal failuresTotal failed connection attempts.
MSAS 2008:ConnectionCurrent user sessionsCurrent number of user sessions established.
MSAS 2008:Data Mining Model ProcessingCases/secRate of processing cases.
MSAS 2008:Data Mining Model ProcessingCurrent models processingCurrent number of models being processed
MSAS 2008:Data Mining PredictionPredictions/secRate of Data Mining prediction queries
MSAS 2008:Data Mining PredictionRows/secRate of predicting rows
MSAS 2008:Data Mining PredictionConcurrent DM queriesCurrent number of Data Mining queries being actively worked on.
MSAS 2008:Data Mining PredictionQueries/secRate of Data Mining queries
MSAS 2008:Data Mining PredictionTotal QueriesTotal Data Mining Queries received by the server
MSAS 2008:Data Mining PredictionTotal RowsTotal Rows returned by Data Mining queries
MSAS 2008:Data Mining PredictionTotal PredictionsTotal Data Mining Prediction Queries received by the server
MSAS 2008:LocksCurrent latch waitsCurrent 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:LocksLatch waits/secRate of latch requests that could not be granted immediately and had to wait before being granted.
MSAS 2008:LocksCurrent locksCurrent number of locked objects.
MSAS 2008:LocksCurrent lock waitsCurrent number of clients waiting for a lock.
MSAS 2008:LocksLock requests/secNumber of lock requests per second.
MSAS 2008:LocksUnlock requests/secNumber of unlock requests per second.
MSAS 2008:LocksLock grants/secNumber of lock grants per second.
MSAS 2008:LocksLock denials/secRate of lock denials.
MSAS 2008:LocksLock waits/secNumber 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:LocksTotal deadlocks detectedTotal number of deadlocks detected.
MSAS 2008:MDXNumber of calculation coversTotal number of evaluation nodes built by MDX execution plans including active and cached
MSAS 2008:MDXCurrent number of evaluation nodesCurrent (approximate) number of evaluation nodes built by MDX execution plans including active and cached
MSAS 2008:MDXNumber of Storage Engine evaluation nodesTotal number of Storage Engine evaluation nodes built by MDX execution plans
MSAS 2008:MDXNumber of cell-by-cell evaluation nodesTotal number of cell-by-cell evaluation nodes built by MDX execution plans
MSAS 2008:MDXNumber of bulk-mode evaluation nodesTotal number of bulk-mode evaluation nodes built by MDX execution plans
MSAS 2008:MDXNumber of evaluation nodes that covered a single cellTotal number of evaluation nodes built by MDX execution plans that covered only one cell
MSAS 2008:MDXNumber of evaluation nodes with calculations at the same granularityTotal number of evaluation nodes built by MDX execution plans for which the calculations were at the same granularity as the evaluation node
MSAS 2008:MDXCurrent number of cached evaluation nodesCurrent (approximate) number of cached evaluation nodes built by MDX execution plans
MSAS 2008:MDXNumber of cached Storage Engine evaluation nodesTotal number of cached Storage Engine evaluation nodes built by MDX execution plans
MSAS 2008:MDXNumber of cached bulk-mode evaluation nodesTotal number of cached bulk-mode evaluation nodes built by MDX execution plans
MSAS 2008:MDXNumber of cached 'other' evaluation nodesTotal number of cached evaluation nodes built by MDX execution plans that are neither Storage Engine nor Bulk-mode
MSAS 2008:MDXNumber of evictions of evaluation nodesTotal number of cache evictions of evaluation nodes due to collisions
MSAS 2008:MDXNumber of hash index hits in the cache of evaluation nodesTotal number of hits in the cache of evaluation nodes that were satisfied by the hash index
MSAS 2008:MDXNumber of cell-by-cell hits in the cache of evaluation nodesTotal number of cell-by-cell hits in the cache of evaluation nodes
MSAS 2008:MDXNumber of cell-by-cell misses in the cache of evaluation nodesTotal number of cell-by-cell misses in the cache of evaluation nodes
MSAS 2008:MDXNumber of subcube hits in the cache of evaluation nodesTotal number of subcube hits in the cache of evaluation nodes
MSAS 2008:MDXNumber of subcube misses in the cache of evaluation nodesTotal number of subcube misses in the cache of evaluation nodes
MSAS 2008:MDXTotal Sonar subcubesTotal number of subcubes that query optimizer generated
MSAS 2008:MDXTotal cells calculatedTotal number of cell properties calculated
MSAS 2008:MDXTotal recomputesTotal number of cells recomputed due to error
MSAS 2008:MDXTotal flat cache insertsTotal number of cell values inserted into flat calculation cache
MSAS 2008:MDXTotal NON EMPTYTotal number of times NON EMPTY algorithms is used
MSAS 2008:MDXTotal NON EMPTY for calculated membersTotal number of times NON EMPTY algorithm was looping over calculated members
MSAS 2008:MDXTotal NON EMPTY unoptimizedTotal number of times unoptimized NON EMPTY algorithm is used
MSAS 2008:MDXTotal AutoexistTotal number of times autoexist performed
MSAS 2008:MDXTotal EXISTINGTotal number of times EXISTING set operator performed
MSAS 2008:MemoryPage Pool 64 Alloc KBMemory borrowed from system, in KB. This memory is given away to other parts of the server.
MSAS 2008:MemoryPage Pool 64 Lookaside KBCurrent memory in 64KB lookaside list, in KB. (Memory pages ready to be used.)
MSAS 2008:MemoryPage Pool 8 Alloc KBMemory borrowed from 64KB page pool, in KB. This memory is given away to other parts of the server.
MSAS 2008:MemoryPage Pool 8 Lookaside KBCurrent memory in 8KB lookaside list, in KB. (Memory pages ready to be used.)
MSAS 2008:MemoryPage Pool 1 Alloc KBMemory borrowed from 64KB page pool, in KB. This memory is given away to other parts of the server.
MSAS 2008:MemoryPage Pool 1 Lookaside KBCurrent memory in 8KB lookaside list, in KB. (Memory pages ready to be used.)
MSAS 2008:MemoryCleaner Current PriceCurrent price of memory, $/byte/time, normalized to 1000.
MSAS 2008:MemoryCleaner Balance/secRate of balance+shrink operations.
MSAS 2008:MemoryCleaner Memory shrunk KB/secRate of shrinking, in KB/sec.
MSAS 2008:MemoryCleaner Memory shrinkable KBAmount of memory, in KB, subject to purging by the background cleaner.
MSAS 2008:MemoryCleaner Memory nonshrinkable KBAmount of memory, in KB, not subject to purging by the background cleaner.
MSAS 2008:MemoryCleaner Memory KBAmount of memory, in KB, known to the background cleaner. (Cleaner memory shrinkable + Cleaner memory nonshrinkable.)
MSAS 2008:MemoryMemory Usage KBMemory usage of the server process. Same as perfmon counter for Process\PrivateBytes.
MSAS 2008:MemoryMemory Limit Low KBLow memory limit, from configuration file.
MSAS 2008:MemoryMemory Limit High KBHigh memory limit, from configuration file.
MSAS 2008:MemoryAggCacheKBCurrent memory allocated to aggregation cache, in KB.
MSAS 2008:MemoryQuota KBCurrent memory quota, in KB. Memory quota is also known as a memory grant or memory reservation.
MSAS 2008:MemoryQuota BlockedCurrent number of quota requests that are blocked until other memory quotas are freed.
MSAS 2008:MemoryFilestore KBCurrent memory allocated to filestore (file cache), in KB.
MSAS 2008:MemoryFilestore Page Faults/secFilestore page fault rate.
MSAS 2008:MemoryFilestore Reads/secFilestore pages read/sec.
MSAS 2008:MemoryFilestore KB Reads/secFilestore KB read/sec.
MSAS 2008:MemoryFilestore Writes/secFilestore pages written/sec. The writes are asynchronous.
MSAS 2008:MemoryFilestore KB Write/secFilestore KB written/sec. The writes are asynchronous.
MSAS 2008:MemoryFilestore IO Errors/secFilestore IO Error rate.
MSAS 2008:MemoryFilestore IO ErrorsFilestore IO Errors total.
MSAS 2008:MemoryFilestore Clock Pages Examined/secRate of background cleaner examining pages for eviction consideration.
MSAS 2008:MemoryFilestore Clock Pages HaveRef/secRate of background cleaner examining pages that have a current reference count (are currently in use).
MSAS 2008:MemoryFilestore Clock Pages Valid/secRate of background cleaner examining pages that are valid candidates for eviction.
MSAS 2008:MemoryFilestore Memory Pinned KBCurrent filestore memory pinned KB.
MSAS 2008:MemoryIn-memory Dimension Property File KBCurrent in-memory dimension property file KB.
MSAS 2008:MemoryIn-memory Dimension Property File KB/secIn-memory dimension property file KB rate.
MSAS 2008:MemoryPotential In-memory Dimension Property File KBPotential in-memory dimension property file KB.
MSAS 2008:MemoryDimension Property FilesNumber of dimension property files.
MSAS 2008:MemoryIn-memory Dimension Index (Hash) File KBCurrent in-memory dimension index (hash) file KB.
MSAS 2008:MemoryIn-memory Dimension Index (Hash) File KB/secIn-memory dimension index (hash) file KB rate.
MSAS 2008:MemoryPotential In-memory Dimension Index (Hash) File KBPotential in-memory dimension index (hash) file KB.
MSAS 2008:MemoryDimension Index (Hash) FilesNumber of dimension index (hash) files.
MSAS 2008:MemoryIn-memory Dimension String File KBCurrent in-memory dimension string file KB.
MSAS 2008:MemoryIn-memory Dimension String File KB/secIn-memory dimension string file KB rate.
MSAS 2008:MemoryPotential In-memory Dimension String File KBPotential in-memory dimension string file KB.
MSAS 2008:MemoryDimension String FilesNumber of dimension string files.
MSAS 2008:MemoryIn-memory Map File KBCurrent in-memory map file KB.
MSAS 2008:MemoryIn-memory Map File KB/secIn-memory map file KB rate.
MSAS 2008:MemoryPotential In-memory Map File KBPotential in-memory map file KB.
MSAS 2008:MemoryMap FilesNumber of map files.
MSAS 2008:MemoryIn-memory Aggregation Map File KBCurrent in-memory aggregation map file KB.
MSAS 2008:MemoryIn-memory Aggregation Map File KB/secIn-memory aggregation map file KB rate.
MSAS 2008:MemoryPotential In-memory Aggregation Map File KBPotential in-memory aggregation map file KB.
MSAS 2008:MemoryAggregation Map FilesNumber of aggregation map files.
MSAS 2008:MemoryIn-memory Fact Data File KBCurrent in-memory fact data file KB.
MSAS 2008:MemoryIn-memory Fact Data File KB/secIn-memory fact data file KB rate.
MSAS 2008:MemoryPotential In-memory Fact Data File KBPotential in-memory fact data file KB.
MSAS 2008:MemoryFact Data FilesNumber of fact data files.
MSAS 2008:MemoryIn-memory Fact String File KBCurrent in-memory fact string file KB.
MSAS 2008:MemoryIn-memory Fact String File KB/secIn-memory fact string file KB rate.
MSAS 2008:MemoryPotential In-memory Fact String File KBPotential in-memory fact string file KB.
MSAS 2008:MemoryFact String FilesNumber of fact string files.
MSAS 2008:MemoryIn-memory Fact Aggregation File KBCurrent in-memory fact aggregation file KB.
MSAS 2008:MemoryIn-memory Fact Aggregation File KB/secIn-memory fact aggregation file KB rate.
MSAS 2008:MemoryPotential In-memory Fact Aggregation File KBPotential in-memory fact aggregation file KB.
MSAS 2008:MemoryFact Aggregation FilesNumber of fact aggregation files.
MSAS 2008:MemoryIn-memory Other File KBCurrent in-memory other file KB.
MSAS 2008:MemoryIn-memory Other File KB/secIn-memory other file KB rate.
MSAS 2008:MemoryPotential In-memory Other File KBPotential in-memory other file KB.
MSAS 2008:MemoryOther FilesNumber of other files.
MSAS 2008:Proactive CachingNotifications/secRate of notifications from relational database.
MSAS 2008:Proactive CachingProcessing Cancellations/secRate of processing cancellations caused by notifications.
MSAS 2008:Proactive CachingProactive Caching Begin/secRate of proactive caching begin.
MSAS 2008:Proactive CachingProactive Caching Completion/secRate of proactive caching completion.
MSAS 2008:Proc AggregationsCurrent partitionsCurrent number of partitions being processed.
MSAS 2008:Proc AggregationsTotal partitionsTotal number of partitions processed (successfully or otherwise).
MSAS 2008:Proc AggregationsMemory size rowsSize of current aggregations in memory. This count is an estimate.
MSAS 2008:Proc AggregationsMemory size bytesSize of current aggregations in memory. This count is an estimate.
MSAS 2008:Proc AggregationsRows merged/secRate of rows merged or inserted into an aggregation.
MSAS 2008:Proc AggregationsRows created/secRate of aggregation rows created.
MSAS 2008:Proc AggregationsTemp file rows written/secRate of writing rows to a temporary file. Temporary files are written when aggregations exceed memory limits.
MSAS 2008:Proc AggregationsTemp file bytes written/secRate of writing bytes to a temporary file. Temporary files are written when aggregations exceed memory limits.
MSAS 2008:Proc IndexesCurrent partitionsCurrent number of partitions being processed.
MSAS 2008:Proc IndexesTotal partitionsTotal number of partitions processed (successfully or otherwise).
MSAS 2008:Proc IndexesRows/secRate of rows from MOLAP files used to create indexes.
MSAS 2008:Proc IndexesTotal rowsTotal rows from MOLAP files used to create indexes.
MSAS 2008:ProcessingRows read/secRate of rows read from all relational databases.
MSAS 2008:ProcessingTotal rows readCount of rows read from all relational databases.
MSAS 2008:ProcessingRows converted/secRate of rows converted during processing.
MSAS 2008:ProcessingTotal rows convertedCount of rows converted during processing.
MSAS 2008:ProcessingRows written/secRate of rows written during processing.
MSAS 2008:ProcessingTotal rows writtenCount of rows written during processing.
MSAS 2008:Storage Engine QueryCurrent measure group queriesCurrent number of measure group queries being actively worked on.
MSAS 2008:Storage Engine QueryMeasure group queries/secRate of measure group queries
MSAS 2008:Storage Engine QueryTotal measure group queriesTotal number of queries to measure group.
MSAS 2008:Storage Engine QueryCurrent dimension queriesCurrent number of dimension queries being actively worked on.
MSAS 2008:Storage Engine QueryDimension queries/secRate of dimension queries
MSAS 2008:Storage Engine QueryTotal dimension queries.Total number of dimension queries.
MSAS 2008:Storage Engine QueryQueries answered/secRate of queries answered.
MSAS 2008:Storage Engine QueryTotal queries answeredTotal number of queries answered.
MSAS 2008:Storage Engine QueryBytes sent/secRate of bytes sent by server to clients, in response to queries.
MSAS 2008:Storage Engine QueryTotal bytes sentTotal bytes sent by server to clients, in response to queries.
MSAS 2008:Storage Engine QueryRows sent/secRate of rows sent by server to clients.
MSAS 2008:Storage Engine QueryTotal rows sentTotal rows sent by server to clients.
MSAS 2008:Storage Engine QueryQueries from cache direct/secRate of queries answered from cache directly.
MSAS 2008:Storage Engine QueryQueries from cache filtered/secRate of queries answered by filtering existing cache entry.
MSAS 2008:Storage Engine QueryQueries from file/secRate of queries answered from files.
MSAS 2008:Storage Engine QueryTotal queries from cache directTotal number of queries derived directly from cache. Note that this is per partition.
MSAS 2008:Storage Engine QueryTotal queries from cache filteredTotal queries answered by filtering existing cache entries.
MSAS 2008:Storage Engine QueryTotal queries from fileTotal number of queries answered from files.
MSAS 2008:Storage Engine QueryMap reads/secNumber of logical read operations using the Map file.
MSAS 2008:Storage Engine QueryMap bytes/secBytes read from the Map file.
MSAS 2008:Storage Engine QueryData reads/secNumber of logical read operations using the Data file.
MSAS 2008:Storage Engine QueryData bytes/secBytes read from the Data file.
MSAS 2008:Storage Engine QueryAvg time/queryAverage time per query, in milliseconds. Response time based on queries answered since the last counter measurement.
MSAS 2008:Storage Engine QueryNetwork round trips/secRate of network round trips. This includes all client/server communication.
MSAS 2008:Storage Engine QueryTotal network round tripsTotal network round trips. This includes all client/server communication.
MSAS 2008:Storage Engine QueryFlat cache lookups/secRate of flat cache lookups. This includes global, session, and query scope flat caches.
MSAS 2008:Storage Engine QueryFlat cache hits/secRate of flat cache hits. This includes global, session, and query scope flat caches.
MSAS 2008:Storage Engine QueryCalculation cache lookups/secRate of calculation cache lookups. This includes global, session, and query scope calculation caches.
MSAS 2008:Storage Engine QueryCalculation cache hits/secRate of calculation cache hits. This includes global, session, and query scope calculation caches.
MSAS 2008:Storage Engine QueryPersisted cache lookups/secRate of persisted cache lookups. Persisted caches are created by the MDX script CACHE statement.
MSAS 2008:Storage Engine QueryPersisted cache hits/secRate of persisted cache hits. Persisted caches are created by the MDX script CACHE statement.
MSAS 2008:Storage Engine QueryDimension cache lookups/secRate of dimension cache lookups.
MSAS 2008:Storage Engine QueryDimension cache hits/secRate of dimension cache hits.
MSAS 2008:Storage Engine QueryMeasure group cache lookups/secRate of measure group cache lookups.
MSAS 2008:Storage Engine QueryMeasure group cache hits/secRate of measure group cache hits.
MSAS 2008:Storage Engine QueryAggregation lookups/secRate of aggregation lookups.
MSAS 2008:Storage Engine QueryAggregation hits/secRate of aggregation hits.
MSAS 2008:ThreadsShort parsing idle threadsNumber of idle threads in the short parsing thread pool.
MSAS 2008:ThreadsShort parsing busy threadsNumber of busy threads in the short parsing thread pool.
MSAS 2008:ThreadsShort parsing job queue lengthNumber of jobs in the queue of the short parsing thread pool.
MSAS 2008:ThreadsShort parsing job rateRate of jobs through the short parsing thread pool.
MSAS 2008:ThreadsLong parsing idle threadsNumber of idle threads in the long parsing thread pool.
MSAS 2008:ThreadsLong parsing busy threadsNumber of busy threads in the long parsing thread pool.
MSAS 2008:ThreadsLong parsing job queue lengthNumber of jobs in the queue of the long parsing thread pool.
MSAS 2008:ThreadsLong parsing job rateRate of jobs through the long parsing thread pool.
MSAS 2008:ThreadsQuery pool idle threadsNumber of idle threads in the query thread pool.
MSAS 2008:ThreadsQuery pool busy threadsNumber of busy threads in the query thread pool.
MSAS 2008:ThreadsQuery pool job queue lengthNumber of jobs in the queue of the query thread pool.
MSAS 2008:ThreadsQuery pool job rateRate of jobs through the query thread pool.
MSAS 2008:ThreadsProcessing pool idle threadsNumber of idle threads in the processing thread pool.
MSAS 2008:ThreadsProcessing pool busy threadsNumber of busy threads in the processing thread pool.
MSAS 2008:ThreadsProcessing pool job queue lengthNumber of jobs in the queue of the processing thread pool.
MSAS 2008:ThreadsProcessing pool job rateRate of jobs through the processing thread pool.
 

Tags: non empty, performance

 

2007-2015 VidasSoft Systems Inc.