| 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 TotalMemoryLimit configuration for the SSAS instance is higher than the specified threshold, in order to ensure that the SQL server process has sufficient memory. | Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.Instance.ConfigurationConflictWithSQLServer | Microsoft.SQLServer.2012.AnalysisServices.Instance | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2012.AnalysisServices.MonitorType.Instance.ConfigurationConflictWithSQLServer | True | Public | |
| CPU utilization | The monitor alerts if the CPU usage by the SSAS process is close to 100\%. | Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.Instance.CpuUsage | Microsoft.SQLServer.2012.AnalysisServices.Instance | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2012.AnalysisServices.MonitorType.Instance.CpuUsage | True | Public | |
| Default Storage Free Space | The monitor reports a warning when the available free space for the default storage for the instance drops below the Warning Threshold setting, expressed as percentage of the sum of estimated default storage folder (DataDir) size and disk free space. The monitor reports a critical alert when the available space drops below the Critical Threshold. The monitor does not take into account databases or partitions located in folders other than the default storage folder (DataDir). | Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.Instance.FreeSpace | Microsoft.SQLServer.2012.AnalysisServices.Instance | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2012.AnalysisServices.MonitorType.Instance.FreeSpacePercent | True | Public | |
| Memory Usage | The monitor reports a warning when memory allocations by the SSAS instance surpass the configured WarningThreshold, expressed as a percentage of the TotalMemoryLimit setting for the SSAS instance. The monitor issues a critical alert when these allocations surpass the configured CriticalThreshold. | Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.Instance.MemoryUsage | Microsoft.SQLServer.2012.AnalysisServices.Instance | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2012.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 the TotalMemoryLimit for Analysis Services is always available. | Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.Instance.MemoryUsageByOtherProcess | Microsoft.SQLServer.2012.AnalysisServices.Instance | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2012.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 the SSAS instance is greater than the configured threshold. | Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.Instance.ProcessingPoolIOJobQueueLength | Microsoft.SQLServer.2012.AnalysisServices.Instance | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2012.AnalysisServices.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.2012.AnalysisServices.UnitMonitor.Instance.ProcessingPoolJobQueueLength | Microsoft.SQLServer.2012.AnalysisServices.Instance | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2012.AnalysisServices.MonitorType.Instance.CommonPerformanceData | True | Public | |
| Query Pool Queue length | The monitor alerts when the size of query pool queue for the SSAS instance is greater than the configured threshold. | Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.Instance.QueryPoolQueueLength | Microsoft.SQLServer.2012.AnalysisServices.Instance | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2012.AnalysisServices.MonitorType.Instance.CommonPerformanceData | True | Public | |
| Service State | The monitor alerts when the windows service for the SSAS instance is not in running state for a duration greater than the configured threshold. | Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.Instance.ServiceState | Microsoft.SQLServer.2012.AnalysisServices.Instance | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2012.AnalysisServices.MonitorType.Instance.ServiceState | True | Public | |
| TotalMemoryLimit Configuration | The monitor alerts when the configured TotalMemoryLimit for the SSAS instance exceeds the configured threshold, risking allocation of physical memory required for the operating system to perform necessary basic functions, at least 2 GB. | Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.Instance.TotalMemoryConfiguration | Microsoft.SQLServer.2012.AnalysisServices.Instance | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2012.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.2012.AnalysisServices.UnitMonitor.MultidimensionalDatabase.BlockedSessionsNumber | Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2012.AnalysisServices.MonitorType.Database.BlockedSessionsNumber | True | Public | |
| Blocking Duration | The monitor alerts if at least one session is blocked longer than the configured threshold. | Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.MultidimensionalDatabase.BlockingDuration | Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2012.AnalysisServices.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 the Critical Threshold. The monitor does not take into account partitions located in folders other than the DB storage folder. | Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.MultidimensionalDatabase.FreeSpace | Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2012.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 the CriticalThreshold 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 WarningThreshold. The monitor does not monitor available space for the default storage location for the SSAS instance. | Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.Partition.FreeSpace | Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalPartition | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2012.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.2012.AnalysisServices.UnitMonitor.TabularDatabase.BlockedSessionsNumber | Microsoft.SQLServer.2012.AnalysisServices.TabularDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2012.AnalysisServices.MonitorType.Database.BlockedSessionsNumber | True | Public | |
| Blocking Duration | The monitor alerts if at least one session is blocked longer than the configured threshold. | Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.TabularDatabase.BlockingDuration | Microsoft.SQLServer.2012.AnalysisServices.TabularDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2012.AnalysisServices.MonitorType.Database.BlockingDuration | True | Public | |
| Database Free Space | The monitor reports a warning when the available disk space for the 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. | Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.TabularDatabase.FreeSpace | Microsoft.SQLServer.2012.AnalysisServices.TabularDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2012.AnalysisServices.MonitorType.Database.FreeSpacePercent | True | Public | |