DB Size Monitor Script 1

[muftak]

Does anyone know of an sp, or have a script that will return ONLY the amount of Used Data Space?

Any help would be appreciated.

 

[nowayout]

try this hope this helps

exec sp_MSforeachdb 'Use [?] exec sp_spaceused'

 

[muftak]

Thanks nowayout .... but I'm looking for a way to return just a single number, the amount of Used Data Space in a single DB. For example, in mysql, I do something like:

echo "SIZE: $SIZE"

 

[tlbroadbent]

--return the databse size in MB
Use YourDatabase

Select DBSize=cast(8.0*sum(Size)/1024. As Decimal(10,2))
From sysfiles

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[muftak]

Thanks tlbroadbent ... but again, I'm just looking for the USED DATA SPACE.

Example: DB is 1GB, 524MB is used 500MB is free. I'm looking for a way to return just the 524MB number.

I haven't been able to find away to just get that number returned, which is why I've posted here.

 

[tlbroadbent]

--return the database space used in MB
Select DBSpaceUsed = cast(8.0*sum(Reserved)/1024. As Decimal(15,2))
from sysindexes
where indid in (0, 1, 255)

You may need to run exec sp_spaceused @updateusage='true' to update statistics so the correct size is returned.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[muftak]

Thank You very much ... that works perfectly.