Geeks With Blogs

News My Blog has been MOVED to
Michael Freidgeim's OLD Blog My Blog has been MOVED to

An article Data files: To Autogrow Or Not To Autogrow? recommends NOT to rely on auto-grow, because it causing delays in unplanned times.

We should mtonitor database files(both data and log), and if they close to max capacity, manually increase the size.
 However it doesn't give references, how to monitor the free space inside databases.
I've tried to look how to do it. 

It can be done manually using   
execute sp_spaceused for the database in question or 
sp_SOS (can be downloaded from

Alternatively you can run SQL commands as suggested in Http:// by Michael Valentine Jones

[FREE_SPACE_MB] = convert(decimal(12,2),round((a.size-fileproperty(,'SpaceUsed'))/128.000,2)) 
from dbo.sysfiles a

More useful article Monitor database file sizes with SQL Server Jobs describes how to setup monitoring

 Finally I found the excellent article

Managing Database Data Usage With Custom Space Alerts, that can be followed even support personnel without much DBA experience.

Posted on Sunday, September 30, 2012 11:44 AM SQL Server | Back to top

Comments on this post: Monitoring Database disk space

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Michael Freidgeim | Powered by: