| | DisplayName | Description | ID | Target | Category | Enabled | Instance Name | Counter Name | Frequency | Event_ID | Event Source | Alert Generate | Alert Severity | Alert Priority | Remotable | Event Log |
|---|
 | SSAS: Actual System Cache (GB) | This rule collects the size in gigabytes of system cache on the computer, where SSAS instance is installed. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.ActualSystemCache | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Cache Evictions/sec | This rule collects SSAS rate of evictions from the cache. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.CacheEvictionsPerSec | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Cache Inserts/sec | This rule collects SSAS rate of insertions into the cache. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.CacheInsertsPerSec | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Cache added KB/sec | This rule collects SSAS rate of memory added to the cache, KB/sec. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.CacheKBAddedPerSec | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: CPU utilization (\%) | This rule collects rate of CPU usage by SSAS Instance. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.CpuUsage | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Default Storage Folder Size (GB) | This rule collects the total size in gigabytes of the default storage folder (Data Directory) for SSAS instance, calculated as a sum of estimated sizes of the DBs and partitions located in the Data Directory. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.DefaultFolderSize | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Instance Free Space (GB) | This rule collects the amount of free space in gigabytes on the drive, where the default storage folder (Data Directory) for SSAS instance is located. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.FreeSpace | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Instance Free Space (\%) | This rule collects the amount of free space on the drive, where the default storage folder (Data Directory) for SSAS instance is located, expressed as percentage of the sum of estimated default storage folder (Data Directory) size and disk free space. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.FreeSpacePercent | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Low Memory Limit (GB) | This rule collects the current configuration for the Low Memory Limit of SSAS instance in gigabytes. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.LowMemoryLimit | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Cleaner Current Price | This rule collects current cost of memory as calculated by SSAS (cost per byte per unit of time) normalized and expressed on a scale from 0 to 1000. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.MemoryCostPerfomance | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Memory Usage on the Server (GB) | This rule collects total memory usage in gigabytes on the server, where SSAS instance is installed. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.MemoryUsageOnTheServer | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Memory Usage on the Server (\%) | This rule collects total memory usage in percent on the server, where SSAS instance is installed. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.MemoryUsageOnTheServerPercent | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Memory Usage by AS Non-shrinkable (GB) | This rule collects non-shrinkable memory in gigabytes allocated by SSAS instance. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.NonShrinkableMemory | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Processing Pool I/O Job Queue Length | This rule collects the length of SSAS processing pool I/O job queue. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.ProcessingPoolIOJobQueueLength | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Processing Pool Job Queue Length | This rule collects the length of the processing pool job queue. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.ProcessingPoolJobQueueLength | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Processing Rows read/sec | This rule collects Rate of rows read from all relational databases. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.ProcessingRowsReadPerSec | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Instance Memory (GB) | This rule collects the total size in gigabytes of memory allocated by SSAS instance. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.ProcessTotalMemory | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Instance Memory (\%) | This rule collects the total size in percent of memory allocated by SSAS instance. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.ProcessTotalMemoryPercent | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Query Pool Job Queue Length | This rule collects the length of the query pool job queue. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.QueryPoolQueueLength | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Storage Engine Query Rows sent/sec | This rule collects Rate of rows sent by server to clients. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.StorageEngineQueryRowsSentPerSec | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Total Drive Size (GB) | This rule collects the total size in gigabytes of the drive, where the default storage folder (Data Directory) for SSAS instance is located. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.TotalDriveSize | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Total Memory on the Server (GB) | This rule collects the total size of memory in gigabytes on the computer, where SSAS instance is running. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.TotalMemory | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Total Memory Limit (GB) | This rule collects the configuration on SSAS instance for 'Total Memory Limit' in gigabytes. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.TotalMemoryLimit | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Used Space on Drive (GB) | This rule collects the total amount of used disk space on the disk, where SSAS instance Data Directory is located. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.UsedDriveSpace | Microsoft.SQLServer.AnalysisServices.Windows.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Database Blocking Duration (minutes) | This rule collects the longest blocking duration for currently blocked sessions. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.MultidimensionalDatabase.BlockingDuration | Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Database Disk Free Space (GB) | This rule collects the amount of free space on the drive, where the database is located. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.MultidimensionalDatabase.DiskFreeSpace | Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Database Drive Space Used By Others (GB) | This rule collects the amount of used space on the drive, where the database is located, other than space used by the database itself. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.MultidimensionalDatabase.DriveSpaceUsedByOthers | Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Database Free Space (GB) | This rule collects the amount of free space in gigabytes on the drive, where the storage folder of the database is located. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.MultidimensionalDatabase.FreeSpace | Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Database Free Space (\%) | This rule collects the amount of free space on the drive, where the storage folder of the database is located, expressed as percentage of the sum of estimated database storage folder size and disk free space. This rule does not take into account partitions located in folders other than the DB storage folder. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.MultidimensionalDatabase.FreeSpacePercent | Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Number of Database Blocked Sessions | This rule collects the number of sessions that are currently blocked. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.MultidimensionalDatabase.NumberOfBlockedSessions | Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Database Storage Folder Size (GB) | This rule collects the estimated size of the database storage folder in gigabytes. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.MultidimensionalDatabase.StorageFolderSize | Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Total Drive Size (GB) | This rule collects the total size in gigabytes of the drive, where the database storage folder is located. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.MultidimensionalDatabase.TotalDriveSize | Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Database Size (GB) | This rule collects the total estimated database size in gigabytes including size of all partitions. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.MultidimensionalDatabase.TotalSize | Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Drive Used Space (GB) | This rule collects the total size in gigabytes of all files and folders on the drive, where the database storage folder is located. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.MultidimensionalDatabase.UsedDriveSpace | Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Partition Free Space (GB) | This rule collects the amount of free space in gigabytes on the drive, where the storage folder of the partition is located. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.MultidimensionalPartition.FreeSpace | Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalPartition | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Partition Free Space (\%) | This rule collects the size of free space on the drive, where the partition storage is located, expressed as percentage of the sum of the partition storage folder total size plus disk free space. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.MultidimensionalPartition.FreeSpacePercent | Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalPartition | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Partition Size (GB) | This rule collects the estimated size of the partition in gigabytes. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.MultidimensionalPartition.PartitionSize | Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalPartition | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Partition Used by Others (GB) | This rule collects the total amount of space in gigabytes on the drive, where the storage folder of the partition is located, which is allocated by files and folders other than the storage folder of the partition. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.MultidimensionalPartition.UsedByOthers | Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalPartition | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Database Blocking Duration (minutes) | This rule collects the longest blocking duration for currently blocked sessions. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.TabularDatabase.BlockingDuration | Microsoft.SQLServer.AnalysisServices.Windows.TabularDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Database Disk Free Space (GB) | This rule collects the amount of free space on the drive, where the database is located. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.TabularDatabase.DiskFreeSpace | Microsoft.SQLServer.AnalysisServices.Windows.TabularDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Database Drive Space Used By Others (GB) | This rule collects the amount of used space on the drive, where the database is located, other than space used by database itself. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.TabularDatabase.DriveSpaceUsedByOthers | Microsoft.SQLServer.AnalysisServices.Windows.TabularDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Database Free Space (GB) | This rule collects the amount of free space in gigabytes on the drive, where the storage folder of the database is located. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.TabularDatabase.FreeSpace | Microsoft.SQLServer.AnalysisServices.Windows.TabularDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Database Free Space (\%) | This rule collects the amount of free space on the drive, where the storage folder of the database is located, expressed as percentage of the sum of estimated database storage folder size and disk free space. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.TabularDatabase.FreeSpacePercent | Microsoft.SQLServer.AnalysisServices.Windows.TabularDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Number of Database Blocked Sessions | This rule collects the number of sessions that are currently blocked. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.TabularDatabase.NumberOfBlockedSessions | Microsoft.SQLServer.AnalysisServices.Windows.TabularDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Database Storage Folder Size (GB) | This rule collects the size of the database storage folder in gigabytes. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.TabularDatabase.StorageFolderSize | Microsoft.SQLServer.AnalysisServices.Windows.TabularDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Total Drive Size (GB) | This rule collects the total size in gigabytes of the drive, where the database storage folder is located. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.TabularDatabase.TotalDriveSize | Microsoft.SQLServer.AnalysisServices.Windows.TabularDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Database Size (GB) | This rule collects the total database size in gigabytes. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.TabularDatabase.TotalSize | Microsoft.SQLServer.AnalysisServices.Windows.TabularDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Drive Used Space (GB) | This rule collects the total size in gigabytes of all files and folders on the drive, where the database storage folder is located. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.TabularDatabase.UsedDriveSpace | Microsoft.SQLServer.AnalysisServices.Windows.TabularDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: Database VertiPaq Memory Size (GB) | This rule tracks the VertiPaq memory size of the database in gigabytes. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.TabularDatabase.VertipaqMemorySize | Microsoft.SQLServer.AnalysisServices.Windows.TabularDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: VertiPaq Memory Limit (GB) | This rule collects the configuration on SSAS instance for VertiPaq Memory Limit in gigabytes. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.TabularInstance.VertipaqMemoryLimit | Microsoft.SQLServer.AnalysisServices.Windows.TabularInstance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: VertiPaq Memory Usage on the Server (GB) | This rule collects total VertiPaq memory usage in gigabytes on the server where the SSAS instance is installed. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.TabularInstance.VertiPaqMemoryUsageOnTheServer | Microsoft.SQLServer.AnalysisServices.Windows.TabularInstance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: VertiPaq Memory Usage on the Server (\%) | This rule collects total VertiPaq memory usage in percentage terms from either limit or available memory on the server where the SSAS instance is installed. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.TabularInstance.VertiPaqMemoryUsageOnTheServerPercent | Microsoft.SQLServer.AnalysisServices.Windows.TabularInstance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: VertiPaq Nonpaged Memory (GB) | This rule collects VertiPaq Nonpaged Memory usage in gigabytes. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.TabularInstance.VertipaqNonpagedMemory | Microsoft.SQLServer.AnalysisServices.Windows.TabularInstance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS: VertiPaq Paged Memory (GB) | This rule collects VertiPaq Paged Memory usage in gigabytes. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.TabularInstance.VertipaqPagedMemory | Microsoft.SQLServer.AnalysisServices.Windows.TabularInstance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| An error occurred during the execution of an SSAS MP managed module | This rule oversees the Event Log and watches for error events submitted by SSAS management pack. If one of the workflows (discovery, rule or monitor) fails, an event is logged and a critical alert is reported. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Rule.EventLogCollectionTarget.ModuleError | Microsoft.SQLServer.AnalysisServices.Windows.EventLogCollectionTarget | Alert | True | | | 0 | 0 | | True | Error | High | True | Operations Manager |
Home