Total spaceused and total allocated

[kydongau]

Anyone has a "one sql statement" to get the total spaceused and total
space allocated of an instance ? ie same as sum of relevance fields
from sp_spaceused for each database in an instance, that works accross
version of mssql from 6 onward.
Thanks
KD

[Erland Sommarskog]

Re: Total spaceused and total allocated

kydongau (kydongau@yahoo .com.au) writes:[color=blue]
> Anyone has a "one sql statement" to get the total spaceused and total
> space allocated of an instance ? ie same as sum of relevance fields
> from sp_spaceused for each database in an instance, that works accross
> version of mssql from 6 onward.[/color]

Since the architecture for 6.0/6.5 is radically different from later
versions of SQL Server, there is no statement that works on all versions
of SQL Server.

It would possible to give some rough numbers for 6.0/6.5 with a single
statement, but not for later versions, because the information is spread
out in the various databases.


--
Erland Sommarskog, SQL Server MVP, sommar@algonet. se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp