| | DisplayName | Description | ID | Target | Category | Enabled | Instance Name | Counter Name | Frequency | Event_ID | Event Source | Alert Generate | Alert Severity | Alert Priority | Remotable | Event Log |
|---|
 | An error occurred during execution of a SSAS 2016 MP managed module | The rule oversees the Event Log and watches for error events submitted by SSAS 2016 management pack. If one of the workflows (discovery, rule or monitor) fails, an event is logged and a critical alert is reported. | Microsoft.SQLServer.2016.AnalysisServices.AlertRule.Seed.ModuleError | Microsoft.SQLServer.2016.AnalysisServices.EventLogCollectionTarget | Alert | True | | | 0 | 6200 | SSAS 2016 MP | True | Error | High | True | Operations Manager |
| SSAS 2016: Actual System Cache (GB) | The rule collects the size in gigabytes of system cache on the computer, where SSAS instance is located. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.ActualSystemCache | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Cache Evictions/sec | The rule collects SSAS rate of evictions from the cache. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.CacheEvictionsPerSec | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Cache Inserts/sec | The rule collects SSAS rate of insertions into the cache. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.CacheInsertsPerSec | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Cache added KB/sec | The rule collects SSAS rate of memory added to the cache, KB/sec. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.CacheKBAddedPerSec | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: CPU utilization (\%) | The rule collects rate of CPU usage by SSAS Instance. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.CpuUsage | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Default Storage Folder Size (GB) | The 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.2016.AnalysisServices.PerformanceRule.Instance.DefaultFolderSize | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Instance Free Space (GB) | The rule collects the amount of free space on the drive, where the default storage folder (Data Directory) for SSAS instance is located in gigabytes. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.FreeSpace | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Data Folder Available Space Ratio (\%) | The 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.2016.AnalysisServices.PerformanceRule.Instance.FreeSpacePercent | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Low Memory Limit (GB) | The rule collects the current configuration for the Low Memory Limit of SSAS instance in gigabytes. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.LowMemoryLimit | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: MDX Number of calculation covers | The rule collects Total number of evaluation nodes built by MDX execution plans, including active and cached. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.MDXNumberCalculationCovers | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: MDX total cells calculated | The rule collects Total number of cell properties calculated. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.MDXTotalCellsCalculated | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: MDX Total NON EMPTY for calculated members | The rule collects Total number of times a NON EMPTY algorithm looped over calculated members. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.MDXTotalNONEMPTYCalculatedMembers | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: MDX Total NON EMPTY unoptimized | The rule collects Total number of times an unoptimized NON EMPTY algorithm was used. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.MDXTotalNONEMPTYUnoptimized | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: MDX Total Recomputes | The rule collects Total number of cells recomputed due to error. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.MDXTotalRecomputes | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: MDX Total Sonar subcubes | The rule collects Total number of subcubes that the query optimizer generated. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.MDXTotalSonarSubcubes | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Cleaner Current Price | The 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.2016.AnalysisServices.PerformanceRule.Instance.MemoryCostPerfomance | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Memory Usage on the Server (GB) | The rule collects total memory usage in gigabytes on the server, where SSAS instance is located. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.MemoryUsageOnTheServer | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Memory Usage on the Server (\%) | The rule collects total memory usage in percent on the server, where SSAS instance is located. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.MemoryUsageOnTheServerPercent | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Memory Usage by AS Non-shrinkable (GB) | The rule collects non-shrinkable memory in gigabytes allocated by SSAS instance. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.NonShrinkableMemory | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Processing Aggreagations Rows created/sec | The rule collects Rate of aggregation rows created during processing of aggregations in MOLAP data files. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.ProcessingAggregationsRowsCreatedPerSec | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Indexes Processing Rows/sec | The rule collects Rate of rows from MOLAP files used to create indexes. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.ProcessingIndexesRowsPerSec | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Processing Pool I/O Job Queue Length | The rule collects the length of SSAS processing pool I/O job queue. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.ProcessingPoolIOJobQueueLength | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Processing Pool Job Queue Length | The rule collects the length of the processing pool job queue. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.ProcessingPoolJobQueueLength | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Processing Rows read/sec | The rule collects Rate of rows read from all relational databases. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.ProcessingRowsReadPerSec | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Processing Rows written/sec | The rule collects Rate of rows written during processing of data. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.ProcessingRowsWrittenPerSec | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Instance Memory (GB) | The rule collects the total size in gigabytes of memory allocated by SSAS instance. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.ProcessTotalMemory | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Instance Memory (\%) | The rule collects the total size in percent of memory allocated by SSAS instance. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.ProcessTotalMemoryPercent | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Query Pool Job Queue Length | The rule collects the length of the query pool job queue. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.QueryPoolQueueLength | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Storage Engine Query Rows sent/sec | The rule collects Rate of rows sent by server to clients. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.StorageEngineQueryRowsSentPerSec | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Total Drive Size (GB) | The rule collects the total size in gigabytes of the drive, where the default storage folder (Data Directory) for SSAS instance is located. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.TotalDriveSize | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Total Memory on the Server (GB) | The rule collects the total size of memory in gigabytes on the computer, where SSAS instance is running. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.TotalMemory | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Total Memory Limit (GB) | The rule collects the configuration on SSAS instance for Total Memory Limit in gigabytes. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.TotalMemoryLimit | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Used Space on Drive (GB) | The rule collects the total amount of used disk space on the disk, where SSAS instance Data Directory is located. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.Instance.UsedDriveSpace | Microsoft.SQLServer.2016.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Multidimensional Database Blocking Duration (minutes) | The rule collects the longest blocking duration for currently blocked sessions. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.MultidimensionalDatabase.BlockingDuration | Microsoft.SQLServer.2016.AnalysisServices.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Multidimensional Database Disk Free Space (GB) | The rule collects the amount of free space on the drive, where the database is located. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.MultidimensionalDatabase.DiskFreeSpace | Microsoft.SQLServer.2016.AnalysisServices.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Multidimensional Database Drive Space Used By Others (GB) | The 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.2016.AnalysisServices.PerformanceRule.MultidimensionalDatabase.DriveSpaceUsedByOthers | Microsoft.SQLServer.2016.AnalysisServices.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Multidimensional Database Free Space (GB) | The rule collects the amount of free space in gigabytes on the drive, where the storage folder of the database is located. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.MultidimensionalDatabase.FreeSpace | Microsoft.SQLServer.2016.AnalysisServices.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Multidimensional Database Free Space (\%) | The 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. The rule does not take into account partitions located in folders other than the DB storage folder. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.MultidimensionalDatabase.FreeSpacePercent | Microsoft.SQLServer.2016.AnalysisServices.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Number of Multidimensional Database Blocked Sessions | The rule collects the number of sessions that are currently blocked. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.MultidimensionalDatabase.NumberOfBlockedSessions | Microsoft.SQLServer.2016.AnalysisServices.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Multidimensional Database Storage Folder Size (GB) | The rule collects the estimated size of the database storage folder in gigabytes. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.MultidimensionalDatabase.StorageFolderSize | Microsoft.SQLServer.2016.AnalysisServices.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Multidimensional DB Total Drive Size (GB) | The rule collects the total size in gigabytes of the drive, where the database storage folder is located. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.MultidimensionalDatabase.TotalDriveSize | Microsoft.SQLServer.2016.AnalysisServices.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Multidimensional Database Size (GB) | The rule collects the total estimated database size in gigabytes including size of all partitions. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.MultidimensionalDatabase.TotalSize | Microsoft.SQLServer.2016.AnalysisServices.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Drive Used Space Multidimensional DB (GB) | The rule collects the total size in gigabytes of all files and folders on the drive, where the database storage folder is located. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.MultidimensionalDatabase.UsedDriveSpace | Microsoft.SQLServer.2016.AnalysisServices.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Partition Free Space (GB) | The rule collects the amount of free space in gigabytes on the drive, where the storage folder of the partition is located. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.MultidimensionalPartition.FreeSpace | Microsoft.SQLServer.2016.AnalysisServices.MultidimensionalPartition | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Partition Free Space (\%) | The 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.2016.AnalysisServices.PerformanceRule.MultidimensionalPartition.FreeSpacePercent | Microsoft.SQLServer.2016.AnalysisServices.MultidimensionalPartition | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Partition Size (GB) | The rule collects the estimated size of the partition in gigabytes. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.MultidimensionalPartition.PartitionSize | Microsoft.SQLServer.2016.AnalysisServices.MultidimensionalPartition | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Partition Used by Others (GB) | The 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.2016.AnalysisServices.PerformanceRule.MultidimensionalPartition.UsedByOthers | Microsoft.SQLServer.2016.AnalysisServices.MultidimensionalPartition | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Tabular Database Blocking Duration (minutes) | The rule collects the longest blocking duration for currently blocked sessions. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.TabularDatabase.BlockingDuration | Microsoft.SQLServer.2016.AnalysisServices.TabularDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Tabular Database Disk Free Space (GB) | The rule collects the amount of free space on the drive, where the database is located. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.TabularDatabase.DiskFreeSpace | Microsoft.SQLServer.2016.AnalysisServices.TabularDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Tabular Database Drive Space Used By Others (GB) | The rule collects the amount of used space on the drive, where the database is located, other than space used by database itself. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.TabularDatabase.DriveSpaceUsedByOthers | Microsoft.SQLServer.2016.AnalysisServices.TabularDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Database Free Space (GB) | The rule collects the amount of free space in gigabytes on the drive, where the storage folder of the database is located. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.TabularDatabase.FreeSpace | Microsoft.SQLServer.2016.AnalysisServices.TabularDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Database Free Space (\%) | The 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.2016.AnalysisServices.PerformanceRule.TabularDatabase.FreeSpacePercent | Microsoft.SQLServer.2016.AnalysisServices.TabularDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Number of Tabular Database Blocked Sessions | The rule collects the number of sessions that are currently blocked. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.TabularDatabase.NumberOfBlockedSessions | Microsoft.SQLServer.2016.AnalysisServices.TabularDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Tabular Database Storage Folder Size (GB) | The rule collects the size of the database storage folder in gigabytes. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.TabularDatabase.StorageFolderSize | Microsoft.SQLServer.2016.AnalysisServices.TabularDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Tabular DB Total Drive Size (GB) | The rule collects the total size in gigabytes of the drive, where the database storage folder is located. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.TabularDatabase.TotalDriveSize | Microsoft.SQLServer.2016.AnalysisServices.TabularDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Tabular Database Size (GB) | The rule collects the total database size in gigabytes. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.TabularDatabase.TotalSize | Microsoft.SQLServer.2016.AnalysisServices.TabularDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2016: Drive Used Space of Tabular DB (GB) | The rule collects the total size in gigabytes of all files and folders on the drive, where the database storage folder is located. | Microsoft.SQLServer.2016.AnalysisServices.PerformanceRule.TabularDatabase.UsedDriveSpace | Microsoft.SQLServer.2016.AnalysisServices.TabularDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
Home