• Management Pack:  SQL Server Analysis Services
  • MP Version:  6.7.31.0 for SQL Server 2016 Analysis Services
  • Released:  6/27/2017
  • Publisher:  Microsoft

Unit Monitors

Name Enabled Target Class Alert Message Description
Unit Monitor   Blocking Duration
1
 
SSAS 2016 Multidimensional DB SSAS 2016: At least one session has been blocked for a long period. The monitor alerts, if at least one session is blocked for a longer period than the configured threshold.
Unit Monitor   Blocking Duration
1
 
SSAS 2016 Tabular DB SSAS 2016: At least one session has been blocked for a long period. The monitor alerts, if at least one session is blocked for a longer period than the configured threshold.
Unit Monitor   Blocking Session Count
1
 
SSAS 2016 Multidimensional DB SSAS 2016: Blocking Session Count exceeded The monitor alerts, when the number of sessions that are blocked longer than the configured WaitMinutes setting exceeds the configured threshold.
Unit Monitor   Blocking Session Count
1
 
SSAS 2016 Tabular DB SSAS 2016: Blocking Session Count exceeded The monitor alerts, when the number of sessions that are blocked longer than the configured WaitMinutes setting exceeds the configured threshold.
Unit Monitor   CPU Utilization (%)
1
 
SSAS 2016 Instance SSAS 2016: CPU usage is too high The monitor alerts, if SSAS process CPU usage exceeds the Threshold.
Unit Monitor   Database Free Space
1
 
SSAS 2016 Multidimensional DB SSAS 2016: Insufficient 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.
Unit Monitor   Database Free Space
1
 
SSAS 2016 Tabular DB SSAS 2016: Insufficient 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.
Unit Monitor   Default Storage Free Space
1
 
SSAS 2016 Instance SSAS 2016: Instance default storage lacks sufficient disk 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).
Unit Monitor   Memory Configuration Conflict with SQL Server
1
 
SSAS 2016 Instance SSAS 2016: 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.
Unit Monitor   Memory Usage
1
 
SSAS 2016 Instance SSAS 2016: High Memory Utilization 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.
Unit Monitor   Memory Usage on the Server
1
 
SSAS 2016 Instance SSAS 2016: Other processes have allocated too much memory 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.
Unit Monitor   Partition Storage Free Space
1
 
SSAS 2016 Multidimensional Partition SSAS 2016: The partition storage folder lacks sufficient disk 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.
Unit Monitor   Processing Pool I/O Job Queue length
1
 
SSAS 2016 Instance SSAS 2016: Processing Pool I/O Job Queue length exceeded. The monitor alerts, when the length of the processing pool I/O job queue for SSAS instance is greater than the configured threshold.
Unit Monitor   Processing Pool Job Queue length
1
 
SSAS 2016 Instance SSAS 2016: Processing Pool Job Queue length exceeded. The monitor alerts, when the length of the processing pool job queue for SSAS instance is greater than the configured threshold.
Unit Monitor   Query Pool Queue length
1
 
SSAS 2016 Instance SSAS 2016: Query Pool Job Queue length exceeded The monitor alerts, when the size of query pool queue for SSAS instance is greater than the configured threshold.
Unit Monitor   Service State
1
 
SSAS 2016 Instance SSAS 2016: SQL Server Analysis Service Windows service is not running The monitor alerts, when Windows service for SSAS instance is not in running state for a duration greater than the configured threshold.
Unit Monitor   Total Memory Limit Configuration
1
 
SSAS 2016 Instance SSAS 2016: Invalid 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.

See Also for SQL Server Analysis Services Management Pack


Downloads for SQL Server Analysis Services Management Pack

AZURE OPTIMIZATION ASSESSMENT GET STARTED
MIGRATION TO AZURE GET STARTED
SYSTEM CENTER MIGRATION TO AZURE GET STARTED
MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED