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;

Rate

Share

Share

Rate