| SSAS Activity | Rows Transferred: Query Rows Sent / Sec | The rate of rows sent by the server to the clients.| Mode: | S, H | | Type: | Average rows sent per sec |
|
| SSAS Activity | Rows Transferred:
Proc rows read / Sec | The rate of rows read from all relational databases. If you are connected to SQL Server, you should be reading at least 80,000 rows per sec per table being processed.| Mode: | S, H | | Type: | Average rows read per sec |
|
| SSAS Activity | Threads: Formula Engine: Busy | The Processor performance object consists of counters that measure aspects of processor activity. The processor is the part of the computer that performs arithmetic and logical computations, initiates operations on peripherals, and runs the threads of processes. A computer can have multiple processors. The processor object represents each processor as an instance of the object.| Mode: | S, H | | Type: | Last Value |
|
| SSAS Activity | Threads: Formula Engine: Job Rate | The rate of jobs through the query thread pool.| Mode: | S, H | | Type: | Last Value |
|
| SSAS Activity | Threads: Formula Engine: Queued | The number of jobs in the queue of the query thread pool.| Mode: | S, H | | Type: | Last Value |
|
| SSAS Activity | Threads: Storage Engine: Busy | The number of busy threads in the thread pool.| Mode: | S, H | | Type: | Last Value |
|
| SSAS Activity | Threads: Storage Engine: Job Rate | The rate of non IO jobs through the thread pool.| Mode: | S, H | | Type: | Last Value |
|
| SSAS Activity | Threads: Storage Engine: Queued | The number of jobs in the processing thread pool queue.| Mode: | S, H | | Type: | Last Value |
|
| SSAS General | Average Time (ms): Formula Engine
| The average amount of time for a query to be executing in the formula engine. | Mode: | S, H | | Type: | Avg/ms | | Warning range: | 20 Sec | | Critical range: | One Min |
|
| SSAS General | Average Time (ms): SE cached | The average amount of time spent returning data from the storage engine cache.| Mode: | S, H | | Type: | Avg/ms | | Warning range: | > One Sec |
|
| SSAS General | Average Time (ms): SE non-cached | The average amount of time spent returning non-cached data from the storage engine cache. |
| SSAS General | Average Time (ms): Serialization | The average amount of time spent serializing data to disk ( as in data aggregations). |
| SSAS General | Average Time (ms): SQL Queries | The average amount of time spent executing SQL queries from the relational database. |
| SSAS General | Average Time (ms): Processing | Displays the average processing time in milliseconds. Processing in SSAS Involves the SE, and can cause the Cache to become outdated and flushed. This causes a performance hit because when the query is run after processing completes, the SE has to retrieve the necessary data from the Windows file cache or from disk (cold cache). Non 0 values on the indicate that processing is taking place. Processing can be improved by: - Re-scheduling processing when the least querying activity is going on. This helps to avoid resource contention.
- Check the processing type that is being used; Use ProcessIndex instead of ProcessFull when possible.
- Break the measure groups into partitions to reduce the overall amount of work that is done.
|
| SSAS General | MDX: Cells Calculated
| The total number of cell properties calculated. High values for Cells calc’d while the query is executing indicates that the query is doing cell by cell calculations (this is like row by agonizing row in SQL Server) instead of Subspace (block by block) execution. | Mode: | S, H | | Type: | Last Value/sec |
|
| SSAS General | MDX: Calculated Covers | The total number of evaluation nodes built by MDX execution plans including active, and cached. High values for Calc Covers while the query is executing indicates that the query is doing cell by cell calculations (this is like row by agonizing row in SQL Server) instead of Subspace (block by block) execution. | Mode: | S, H | | Type: | Last Value/sec |
|
| SSAS General | MDX: Sonarsubcubes | The total number of subcubes that the query optimizer generated. High values for Sonarsubcubes while the query is executing indicates that the query is doing cell by cell calculations (this is like row by agonizing row in SQL Server) instead of Subspace (block by block) execution. | Mode: | S, H | | Type: | Last Value/sec |
|
| SSAS General | MDX: Recomputes
| The total number of cells recomputed due to error. Recomputes indicate that there were errors in the calculations during query execution. Non 0 values indicate where unnecessary recalculations are taking place and can fall back to cell by cell executions. | Mode: | S, H | | Type: | Last Value/sec |
|
| SSAS General | MDX: NE unopt | The total number of times unoptimized the NON EMPTY algorithm is used. NE unopt helps determine if performance degradation is occurring due to a slower code path. Using a non-empty algorithm can speed up performance. | Mode: | S, H | | Type: | Last Value/sec |
|
| SSAS General | MDX: NE calc memb | The total number of times the NON EMPTY algorithm was looping over calculated members. NE calc memb help determine if performance degradation is occurring due to a slower code path. Using a non-empty algorithm can speed up performance. | Mode: | S, H | | Type: | Last Value/sec |
|
| SSAS Memory | Memory Usage (MB): Shrinkable | SSAS has two general categories of memory, shrinkable and nonshrinkable. Shrinkable memory can be easily reduced and returned back to the OS. Shrinkable memory is the amount of memory in KB that's subject to purging by the background cleaner. |
| SSAS Memory | Memory Usage (MB): Nonshrinkable | SSAS has two general categories of memory, shrinkable and nonshrinkable. Nonshrinkable memory is generally used for more essential system-related tasks such as memory allocators and metadata objects, and is not easily reduced. Nonshrinkable memory is the amount of memory in KB that's not subject to purging by the background cleaner. |
| SSAS Memory | Cache Activity: Cache Inserts | The rate of inserts from the cache.| Mode: | S, H | | Type: | Last Value/sec |
|
| SSAS Memory | Cache Activity: Cache Evictions | The rate of evictions from the cache. Note: This is per partition per cube per database.| Mode: | S, H | | Type: | Last Value/sec | | May correlate: | Background cleaner |
|
| SSAS Memory | Cache Activity: KB added | The rate of memory added to the cache (KB / Sec). |
| SSAS Memory | Cache Activity: KB Shrunk | The rate of shrinking in KB / Sec. |
| SSAS Storage | File Reads KB: by category |
|
| SSAS Storage | File Writes KB: by category |
|
| SSAS Activity | Connections | The current number of client connections established to the Analysis Services server.| Mode: | S | | Type: | Last Value | | Warning range: | > 50 |
|
| SSAS Activity | Sessions | The current number of user sessions established to the Analysis Services server. |
| SSAS Activity | Requests/Sec | The rate of incoming connection requests per second.| Mode: | S | | Type: | Last Value/sec |
|
| SSAS Activity | Failures/Sec | The rate of connection failures per second.| Mode: | S | | Type: | Last Value/sec |
|
| SSAS General | Current Locks | The current number of locked objects. |
| SSAS General | Current Lock Waits | The current number of clients waiting for a lock. |
| SSAS Memory | Cache Hit ratio: Dim percent | The ratio of cache hits from the dimensions. |
| SSAS Memory | Cache Hit ratio: MG percent | The ratio for measure groups. |
| SSAS Memory | Cache Hit ratio: Calc percent |
|
| SSAS Memory | Cache Hit ratio: Flat percent |
|
| SSAS Storage | File Cache Hit Ratio: Read percent | The percent reading to the storage engine cache. |
| SSAS Storage | File Cache Hit Ratio: Write percent | The percent writing to the storage engine cache. |
