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

Database Free Space Monitor

  • ID:  Microsoft.SQLServer.2016.AnalysisServices.UnitMonitor.MultidimensionalDatabase.FreeSpace
  • Description:  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.
  • Target:  SSAS 2016 Multidimensional DB
  • Enabled:  Yes

Operational States

Name State Description
Sufficient Free Space Success  
Minimal Remaining Free Space Warning  
Insufficient Free Space Error  

Overridable Parameters

Parameter Name Default Value Description Override
Critical Threshold (%) 5 Health State changes to Critical, when Database Free Space (%) performance counter drops below the threshold.
Warning Threshold (%) 10 Health State changes to Warning, if Database Free Space (%) performance counter drops below the threshold, but is still higher than Critical Threshold (%).
Interval Seconds 900 The recurring interval of time in seconds in which to run the workflow.
Synchronization Time   The synchronization time specified by using a 24-hour format. May be omitted.
Timeout (seconds) 300 Specifies the time the workflow is allowed to run before being closed and marked as failed.

Alert Details

Monitor State Message Priority Severity Auto Resolution
Insufficient Free Space (Error) SSAS 2016: Insufficient Database Free Space Medium Critical Yes

Run As Profiles

Name
Default

Monitor Knowledgebase

Summary

SSAS multidimensional database folder typically grows over time, while the data is being continuously added from data warehouse sources for the most typical applications of the server. Therefore, the administrators would like to monitor the issue to be sure that there is always sufficient space left in the storage location for the database folder. Note that the administrators would also wish to monitor the available space in partition folders, which can be configured outside the database folder directory structure. Those folders are not monitored by this rule, but rather by SSAS Partition Storage Available Space Monitor.

Causes

When the available disk space on the drive, where the database storage location is configured, becomes too low, some failures may occur, jeopardizing successful data processing, delaying user’s queries, or affecting other applications as well, which share the same allocation of disk space. This appears to be unhealthy for the server. Consequently, it is important to monitor the issue, and ensure that a sufficient margin of available space remains to avoid costly and time-consuming processing failures, which may incur production outages or delays. It is especially actual for dimensions or measure groups that tend to grow quickly over time.

Resolutions

The resolution(s) for low available disk space depend upon the root causes, which must be investigated in each case, when this issue occurs. The condition may be alleviated by any of the following potential approaches:

  • Modify dimension design to remove unnecessary attributes, or limit the scope of the members included from underlying data source to reduce the dimension size.

  • Move measure group partitions to another drive with more available space. Note that this action can switch the partitions to unprocessed state, and will subsequently require reprocessing of the partitions before they will be able to serve the data.

  • Remove data consuming disk space on the same drive with the DB storage folder.

  • Increase the size of the logical drive on which the data folder is stored by means of Disk Manager.

  • Copy the DB data folder in its entirety to a new drive with more available space.

  • Modify the thresholds accordingly to suit the expected workload and conditions in the environment.

  • Disable the monitor entirely, if disk space is not a concern for the instance.

External References

Configure Server Properties in Analysis Services

TechNet documentation for SSAS Performance Counters

SSAS Multidimensional Performance Guide

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