• Management Pack:  SQL Server
  • MP Version:  6.1 for SQL Server 2008
  • Released:  8/5/2010
  • Publisher:  Microsoft

DB Space Free (MB) : DEPRECATED 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 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 (sec) 900  
Synchronization Time    
Lower Threshold -1  
Upper Threshold -1  
Timeout (sec) 300  

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 both thresholds are set to -1. Monitoring using percentage free space is the default behavior. If it is required to monitor using absolute free space, the threshold values for this monitor should be overridden

Causes

An unhealthy state is caused by the database running low on free space. This could be due to 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 Management Pack


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