| DisplayName | Description | ID | Target | Parent Monitor | Category | Enabled | Instance Name | Counter Name | Frequency | Alert Generate | Alert Severity | Alert Priority | Alert Auto Resolve | Monitor Type | Remotable | Accessibility | RunAs |
| Memory Configuration Conflict with SQL Server | The monitor alerts if there is a SQL Server relational database engine process running on the server, and the 'Total Memory Limit' configuration for the SSAS instance is higher than the specified threshold. This is done to ensure that the SQL Server process has sufficient memory. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.Instance.ConfigurationConflictWithSQLServer | Microsoft.SQLServer.AnalysisServices.Windows.Instance | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Instance.ConfigurationConflictWithSQLServer | True | Public | |
| CPU Utilization (\%) | The monitor alerts if a SSAS process consumes more CPU resources than specified by the threshold. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.Instance.CpuUsage | Microsoft.SQLServer.AnalysisServices.Windows.Instance | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Instance.CpuUsage | True | Public | |
| Default Storage Free Space | The monitor reports a warning when the available free space for the default instance storage drops below the 'Warning Threshold' setting expressed as percentage of the sum of estimated default storage folder (Data Directory) size and disk free space. The monitor reports a critical alert when the available space drops below the 'Critical Threshold' setting. The monitor does not take into account databases or partitions located in folders other than the default storage folder (Data Directory). | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.Instance.FreeSpace | Microsoft.SQLServer.AnalysisServices.Windows.Instance | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Instance.FreeSpacePercent | True | Public | |
| Memory consumed by SSAS Instance | The monitor reports a warning when memory allocations by SSAS instance surpass the configured 'Warning Threshold' expressed as a percentage of the 'Total Memory Limit' setting for the SSAS instance. The monitor issues a critical alert when these allocations surpass the configured 'Critical Threshold'. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.Instance.MemoryUsage | Microsoft.SQLServer.AnalysisServices.Windows.Instance | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Instance.MemoryUsagePercent | True | Public | |
| Memory consumed by other processes | The monitor observes the memory usage by non Analysis Services processes on the server to ensure 'Total Memory Limit' for Analysis Services is always available. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.Instance.MemoryUsageByOtherProcess | Microsoft.SQLServer.AnalysisServices.Windows.Instance | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Instance.MemoryUsageByOtherProcessPercent | True | Public | |
| Processing Pool I/O Job Queue length | The monitor alerts when the length of the processing pool I/O job queue for the SSAS instance is greater than the configured threshold. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.Instance.ProcessingPoolIOJobQueueLength | Microsoft.SQLServer.AnalysisServices.Windows.Instance | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Instance.CommonPerformanceData | True | Public | |
| Processing Pool Job Queue length | The monitor alerts when the length of the processing pool job queue for the SSAS instance is greater than the configured threshold. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.Instance.ProcessingPoolJobQueueLength | Microsoft.SQLServer.AnalysisServices.Windows.Instance | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Instance.CommonPerformanceData | True | Public | |
| Query Pool Queue length | The monitor alerts when the size of the query pool queue for the SSAS instance is greater than the configured threshold. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.Instance.QueryPoolQueueLength | Microsoft.SQLServer.AnalysisServices.Windows.Instance | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Instance.CommonPerformanceData | True | Public | |
| Total Memory Limit Configuration | The monitor alerts when the configured Total Memory Limit for the SSAS instance exceeds the configured threshold, risking allocation of physical memory required for the operating system to perform its essential functions, at least 2 GB. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.Instance.TotalMemoryConfiguration | Microsoft.SQLServer.AnalysisServices.Windows.Instance | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Instance.TotalMemoryConfiguration | True | Public | |
| Service State | The monitor alerts when a Windows service for the SSAS instance is not in the running state for a duration greater than the configured threshold. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.Instance.WindowsServiceState | Microsoft.SQLServer.AnalysisServices.Windows.Instance | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Instance.WindowsServiceState | True | Public | |
| Blocking Session Count | The monitor alerts when the number of sessions that are blocked longer than the configured 'WaitMinutes' setting exceeds the configured threshold. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.MultidimensionalDatabase.BlockedSessionsNumber | Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Database.BlockedSessionsNumber | True | Public | |
| Blocking Duration | The monitor alerts if at least one session is blocked for a period longer than the configured threshold. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.MultidimensionalDatabase.BlockingDuration | Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Database.BlockingDuration | True | Public | |
| Database Free Space | The monitor reports a warning when the available disk space for the SSAS multidimensional database storage folder drops below the 'Warning Threshold' setting expressed as percentage of the sum of the estimated database storage folder size plus disk free space. The monitor reports a critical alert, when the available space drops below 'Critical Threshold'. The monitor does not take into account partitions located in folders other than the DB storage folder. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.MultidimensionalDatabase.FreeSpace | Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Database.FreeSpacePercent | True | Public | |
| Multidimensional Database Status | Analysis Services Multidimensional Database Status Monitor | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.MultidimensionalDatabase.Status | Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalDatabase | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Database.Status | True | Public | |
| Partition Storage Free Space | The monitor reports a warning when the available free space for the partition storage location drops below the 'Critical Threshold' setting expressed as percentage of the sum of the total size of the folder plus disk free space. The monitor reports a critical alert when the available space drops below the 'Warning Threshold' setting. The monitor does not monitor available space for the default storage location for the SSAS instance. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.Partition.FreeSpace | Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalPartition | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Partition.FreeSpacePercent | True | Public | |
| Blocking Session Count | The monitor alerts when the number of sessions that are blocked longer than the configured 'WaitMinutes' setting exceeds the configured threshold. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.TabularDatabase.BlockedSessionsNumber | Microsoft.SQLServer.AnalysisServices.Windows.TabularDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Database.BlockedSessionsNumber | True | Public | |
| Blocking Duration | The monitor alerts if at least one session is blocked for a period longer than the configured threshold. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.TabularDatabase.BlockingDuration | Microsoft.SQLServer.AnalysisServices.Windows.TabularDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Database.BlockingDuration | True | Public | |
| Database Free Space | The monitor reports a warning when the available disk space for SSAS tabular database storage folder drops below the 'Warning Threshold' setting expressed as percentage of the sum of the estimated database storage folder size and disk free space. The monitor reports a critical alert when the available space drops below the 'Critical Threshold' setting. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.TabularDatabase.FreeSpace | Microsoft.SQLServer.AnalysisServices.Windows.TabularDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Database.FreeSpacePercent | True | Public | |
| Tabular Database Status | Analysis Services Tabular Database Status Monitor | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.TabularDatabase.Status | Microsoft.SQLServer.AnalysisServices.Windows.TabularDatabase | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Database.Status | True | Public | |
| Database VertiPaq Size | This monitor reports a warning when the amount of VertiPaq memory consumed by SSAS tabular databases exceeds the 'Warning Threshold' override (specified in GB). In cases when tabular databases consume more VertiPaq memory than it is allowed by the 'Critical Threshold' override (specified in GB), the monitor throws a critical alert. | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.TabularDatabase.VertipaqSize | Microsoft.SQLServer.AnalysisServices.Windows.TabularDatabase | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Database.VertipaqMemorySize | True | Public | |