• Management Pack:  SQL Server 2008
  • MP Version:  7.0.4.0
  • Released:  4/18/2018
  • Publisher:  Microsoft

[Deprecated] DB Space Free (MB) Monitor

  • ID:  Microsoft.SQLServer.2008.Database.DBSizeMegabytesMonitor
  • Description:  This monitor is DEPRECATED. Monitors for the free space left in the database in terms of megabytes.
  • Target:  SQL Server 2008 DB
  • Enabled:  No

Operational States

Name State Description
Free Space Critical Error  
Free Space Low Warning  
Free Space Acceptable Success  

Overridable Parameters

Parameter Name Default Value Description Override
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.
Lower Threshold -1 The lower threshold for this monitor.
Upper Threshold -1 The upper threshold for this monitor.
Timeout (seconds) 300 Specifies the time the workflow is allowed to run before being closed and marked as failed.

Run As Profiles

Name
Default

Monitor Knowledgebase

Summary

This monitor checks the database absolute free space in Megabytes to ensure it is above the defined thresholds. A warning or error alert will be raised if it is below one of the defined thresholds.

Databases that have autogrow set will never generate an alert regardless of the reported free space.

Out of the box, this monitor will never cross a threshold, as soon as both thresholds are set to -1. Monitoring using percentage free space is the default behavior. If it is required to monitor usage of absolute free space, the threshold values for this monitor should be overridden

Causes

Unhealthy state is caused by the database running low on free space. This could be due to a rapid growth, or may have been developing slowly over time. Use the following link to view the historic data for this database:

Database Performance Data

Resolutions

This issue may be resolved by either:

  • Allocating more storage for the database

  • Setting at least one datafile to autogrow for the database

Alternatively, if database size is not a concern for the database:

  • Change the thresholds on the monitor for this specific database or all databases

  • Disable the monitor for this specific database or all databases

External References
This monitor does not contain any external references.

See Also for SQL Server 2008 Management Pack


Downloads for SQL Server 2008 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