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

SSAS 2016 Multidimensional DB Class

  • ID:  Microsoft.SQLServer.2016.AnalysisServices.MultidimensionalDatabase
  • Description:  Microsoft SQL Server 2016 Analysis Services Multidimensional Database
  • Class Hierarchy: 
    Object
    Configuration Item
    Logical Entity
    Application Component
    Windows Application Component
    SSAS 2016 Database
    SSAS 2016 Multidimensional DB

  • Attributes:  Public, Hosted
Login
The monitor alerts, if at least one session is blocked for a longer period than the configured threshold. The monitor alerts, when the number of sessions that are blocked longer than the configured WaitMinutes setting exceeds the configured threshold. 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. The monitor alerts, when Windows service for SSAS instance is not in running state for a duration greater than the configured threshold. 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. 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. The monitor alerts, if SSAS process CPU usage exceeds the Threshold. 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). 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. 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. The monitor alerts, when the length of the processing pool I/O job queue for SSAS instance is greater than the configured threshold. The monitor alerts, when the length of the processing pool job queue for SSAS instance is greater than the configured threshold. The monitor alerts, when the size of query pool queue for SSAS instance is greater than the configured threshold. 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 SQL Server 2016 Analysis Services Multidimensional Database An installation of Microsoft SQL Server 2016 Analysis Services, Multidimensional Mode Microsoft SQL Server 2016 Analysis Services Multidimensional Partition

Download diagram as a Visio file

Properties

Display Name Description
Asset Status Asset status
Database Name (Key) Database Name
Display Name Display name of the object.
Drive (Mount Point) Drive (Mount Point)
Notes Notes
Number of Partitions Number of Partitions
Object Status Object status
Storage Location Storage Location

Discovered By

Name Description
SSAS 2016 Multidimensional DB Discovery The object discovery discovers all databases of an instance of Microsoft SQL Server 2016 Analysis Services, Multidimensional Mode.

Relations

Health Source
NameClassType
SSAS 2016 Database, Multidimensional Mode Hosts Partition SSAS 2016 Multidimensional DB Hosting
Owned By User Configuration Item Reference
Affects Customers Configuration Item Reference
Serviced By User Configuration Item Reference
Contains Configuration Item Configuration Item Membership
Is Related to Configuration Item Configuration Item Reference
Config Item References Location Configuration Item Reference
Entity Watched By Perspective Object Reference

Health Target
NameClassType
SSAS 2016 Group Contains Analysis Service Databases, Multidimensional Mode SSAS 2016 Multidimensional DB Membership
SSAS 2016 Multidimensional Mode Hosts Database SSAS 2016 Multidimensional DB Hosting

Class Knowledgebase

Summary
This class does not contain any summary.
External References
This class does not contain any external references.

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