I'd like a tool (I am willing to build it) that once a day goes out and
identifies how much free space is left in my databases and log files.  I'm
aware that notification/alerts can be setup, but I don't need/want it to
constantly be monitoring the space.  Is there a reliable way to script this?

Thanks in advance.

Mark

SQL2K:

For log space, use DBCC SQLPERF(logspace).
For database space, you can iterate each database, executing sp_spaceused.
That is not friendly ouput however, and it is not guaranteed to be
'correct'.

SQL2K5:

Check into the sys.dm_... dynamic management functions.  This might do it:

select sum(reserved_page_count * 8192.0/1048576.0) from
mydb.sys.dm_db_partition_stats

You will again need to iterate through each database and do a dynamic
execution, since that function is specific to each database.


Show quoteHide quote

Hi Mark

You may want to look at
http://www.microsoft.com/technet/scriptcenter/scripts/sql/dbmgmt/sqldbvb03.mspx


John

Ad hoc update to system catalogs is not supported?
Need help with server configuration.
Should be a simple select...
BCP problem on different servers
Problem with scripting in SQL 2005 after SP2
Scheduled backup in SQL Server 2005 Express
Server migration
What's SQL Server without the System DB's?
MDAC will not UPDATE!!!!
SQLBulkCopy Image