| 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 Total Memory Limit configuration for SSAS instance is higher than the specified threshold, in order to ensure that the SQL server process has sufficient memory. | Microsoft.SQLServer.2016.AnalysisServices.UnitMonitor.Instance.ConfigurationConflictWithSQLServer | Microsoft.SQLServer.2016.AnalysisServices.Instance | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.AnalysisServices.MonitorType.Instance.ConfigurationConflictWithSQLServer | True | Public | |
| CPU Utilization (\%) | The monitor alerts, if SSAS process CPU usage exceeds the Threshold. | Microsoft.SQLServer.2016.AnalysisServices.UnitMonitor.Instance.CpuUsage | Microsoft.SQLServer.2016.AnalysisServices.Instance | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.AnalysisServices.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 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 Critical Threshold. The monitor does not take into account databases or partitions located in folders other than the default storage folder (Data Directory). | Microsoft.SQLServer.2016.AnalysisServices.UnitMonitor.Instance.FreeSpace | Microsoft.SQLServer.2016.AnalysisServices.Instance | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.AnalysisServices.MonitorType.Instance.FreeSpacePercent | True | Public | |
| Memory Usage | The monitor reports a warning, when memory allocations by SSAS instance surpass the configured Warning Threshold, expressed as a percentage of Total Memory Limit setting for SSAS instance. The monitor issues a critical alert, when these allocations surpass the configured Critical Threshold. | Microsoft.SQLServer.2016.AnalysisServices.UnitMonitor.Instance.MemoryUsage | Microsoft.SQLServer.2016.AnalysisServices.Instance | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.AnalysisServices.MonitorType.Instance.MemoryUsagePercent | True | Public | |
| Memory Usage on the Server | 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.2016.AnalysisServices.UnitMonitor.Instance.MemoryUsageByOtherProcess | Microsoft.SQLServer.2016.AnalysisServices.Instance | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.AnalysisServices.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 SSAS instance is greater than the configured threshold. | Microsoft.SQLServer.2016.AnalysisServices.UnitMonitor.Instance.ProcessingPoolIOJobQueueLength | Microsoft.SQLServer.2016.AnalysisServices.Instance | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.AnalysisServices.MonitorType.Instance.CommonPerformanceData | True | Public | |
| Processing Pool Job Queue length | The monitor alerts, when the length of the processing pool job queue for SSAS instance is greater than the configured threshold. | Microsoft.SQLServer.2016.AnalysisServices.UnitMonitor.Instance.ProcessingPoolJobQueueLength | Microsoft.SQLServer.2016.AnalysisServices.Instance | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.AnalysisServices.MonitorType.Instance.CommonPerformanceData | True | Public | |
| Query Pool Queue length | The monitor alerts, when the size of query pool queue for SSAS instance is greater than the configured threshold. | Microsoft.SQLServer.2016.AnalysisServices.UnitMonitor.Instance.QueryPoolQueueLength | Microsoft.SQLServer.2016.AnalysisServices.Instance | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.AnalysisServices.MonitorType.Instance.CommonPerformanceData | True | Public | |
| Service State | The monitor alerts, when Windows service for SSAS instance is not in running state for a duration greater than the configured threshold. | Microsoft.SQLServer.2016.AnalysisServices.UnitMonitor.Instance.ServiceState | Microsoft.SQLServer.2016.AnalysisServices.Instance | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.AnalysisServices.MonitorType.Instance.ServiceState | True | Public | |
| Total Memory Limit Configuration | The monitor alerts, when the configured Total Memory Limit for 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.2016.AnalysisServices.UnitMonitor.Instance.TotalMemoryConfiguration | Microsoft.SQLServer.2016.AnalysisServices.Instance | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.AnalysisServices.MonitorType.Instance.TotalMemoryConfiguration | 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.2016.AnalysisServices.UnitMonitor.MultidimensionalDatabase.BlockedSessionsNumber | Microsoft.SQLServer.2016.AnalysisServices.MultidimensionalDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.AnalysisServices.MonitorType.Database.BlockedSessionsNumber | True | Public | |
| Blocking Duration | The monitor alerts, if at least one session is blocked for a longer period than the configured threshold. | Microsoft.SQLServer.2016.AnalysisServices.UnitMonitor.MultidimensionalDatabase.BlockingDuration | Microsoft.SQLServer.2016.AnalysisServices.MultidimensionalDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.AnalysisServices.MonitorType.Database.BlockingDuration | True | Public | |
| Database Free Space | The monitor reports a warning, when the available disk space for SSAS multidimensional database storage folder drops below 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.2016.AnalysisServices.UnitMonitor.MultidimensionalDatabase.FreeSpace | Microsoft.SQLServer.2016.AnalysisServices.MultidimensionalDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.AnalysisServices.MonitorType.Database.FreeSpacePercent | True | Public | |
| Partition Storage Free Space | The monitor reports a warning, when the available free space for the partition storage location drops below 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 Warning Threshold. The monitor does not monitor available space for the default storage location for SSAS instance. | Microsoft.SQLServer.2016.AnalysisServices.UnitMonitor.Partition.FreeSpace | Microsoft.SQLServer.2016.AnalysisServices.MultidimensionalPartition | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.AnalysisServices.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.2016.AnalysisServices.UnitMonitor.TabularDatabase.BlockedSessionsNumber | Microsoft.SQLServer.2016.AnalysisServices.TabularDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.AnalysisServices.MonitorType.Database.BlockedSessionsNumber | True | Public | |
| Blocking Duration | The monitor alerts, if at least one session is blocked for a longer period than the configured threshold. | Microsoft.SQLServer.2016.AnalysisServices.UnitMonitor.TabularDatabase.BlockingDuration | Microsoft.SQLServer.2016.AnalysisServices.TabularDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.AnalysisServices.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 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 Critical Threshold. | Microsoft.SQLServer.2016.AnalysisServices.UnitMonitor.TabularDatabase.FreeSpace | Microsoft.SQLServer.2016.AnalysisServices.TabularDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.AnalysisServices.MonitorType.Database.FreeSpacePercent | True | Public | |