Multidimensional Database Status

Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.MultidimensionalDatabase.Status (UnitMonitor)

Analysis Services Multidimensional Database Status Monitor

Knowledge Base article:

Summary

This monitor checks the status of the Multidimensional database of Microsoft Analysis Service. This is done by running a query against the databases of the Analysis Service instance and returning the state of the database. If you receive an alert from this monitor, action is required in order to bring the database back to an operational state.

Causes

An unhealthy state indicates that the Analysis Service Multidimensional database is currently unavailable.

Overridable Parameters

Name	Description	Default Value
Alert Priority	Defines Alert Priority.	Normal
Alert Severity	Defines Alert Severity.	Match monitor’s health
Enabled	Enables or disables the workflow.	Yes
Generates Alerts	Defines whether the workflow generates an Alert.	Yes
Interval (seconds)	The recurring interval of time in seconds in which to run the workflow.	900
Synchronization Time	The synchronization time specified by using a 24-hour format. May be omitted.
Timeout (seconds)	Specifies the time the workflow is allowed to run before being closed and marked as failed.	200

Element properties:

Target

Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalDatabase

Parent Monitor

System.Health.AvailabilityState

Category

AvailabilityHealth

Enabled

True

Alert Generate

True

Alert Severity

MatchMonitorHealth

Alert Priority

Normal

Alert Auto Resolve

True

Monitor Type

Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Database.Status

Remotable

True

Accessibility

Public

Alert Message

MSSQL Analysis Services on Windows: Multidimensional Database is in offline state

Multidimensional Database {0} in SQL Server Analysis Services Instance {1} is offline. Error message is {2}

RunAs

Default

Source Code:

<UnitMonitor ID="Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.Monitor.MultidimensionalDatabase.Status" Accessibility="Public" Enabled="true" Remotable="true" Priority="Normal" Target="SQLAS!Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalDatabase" TypeID="Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.MonitorType.Database.Status" ParentMonitorID="SystemHealth!System.Health.AvailabilityState" ConfirmDelivery="false">

  <Category>AvailabilityHealth</Category>

  <AlertSettings AlertMessage="Microsoft.SQLServer.AnalysisServices.Windows.Monitor.MultidimensionalDatabase.Status.AlertMessage">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>MatchMonitorHealth</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Target/Property[Type='ASCore!Microsoft.SQLServer.AnalysisServices.Core.Database']/DatabaseName$</AlertParameter1>

      <AlertParameter2>$Target/Host/Property[Type='ASCore!Microsoft.SQLServer.AnalysisServices.Core.Instance']/ServiceName$</AlertParameter2>

      <AlertParameter3>$Data/Context/Property[@Name='ErrorMessage']$</AlertParameter3>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="Good" MonitorTypeStateID="Good" HealthState="Success"/>

    <OperationalState ID="Critical" MonitorTypeStateID="Critical" HealthState="Error"/>

  </OperationalStates>

  <Configuration>

    <ServiceName>$Target/Host/Property[Type='ASCore!Microsoft.SQLServer.AnalysisServices.Core.Instance']/ServiceName$</ServiceName>

    <DatabaseName>$Target/Property[Type='ASCore!Microsoft.SQLServer.AnalysisServices.Core.Database']/DatabaseName$</DatabaseName>

    <ConnectionString>$Target/Host/Property[Type='ASCore!Microsoft.SQLServer.AnalysisServices.Core.Instance']/ConnectionString$</ConnectionString>

    <DataDir>$Target/Host/Property[Type='ASCore!Microsoft.SQLServer.AnalysisServices.Core.Instance']/DataDir$</DataDir>

    <IntervalSeconds>900</IntervalSeconds>

    <SyncTime/>

    <TimeoutSeconds>300</TimeoutSeconds>

  </Configuration>

</UnitMonitor>