Technical Article

Disk space used by the SQL Server instance

,

I have found this query valuable. Sometimes you need to see just overall consumption without any detailed information. It is also useful in overall trend analysis and disk space planning.

select (8.0*sum(size))/1024/1024 TotalGB
from sys.master_files;

Read 28,985 times
(101 in last 30 days)

Rate

3 (3)

You rated this post out of 5. Change rating

Share

Share

Rate

3 (3)

You rated this post out of 5. Change rating