How large is my instance …

--Calculate an instance data mass ...

set nocount off

declare @table table
(dbname varchar(200), dbsize decimal(12,2)) insert into @table select
ltrim(upper(s.name))
as database_name, cast(convert(decimal(12,2),sum(x.size*8/1024))
as varchar(20))
as database_mass from master .. sysaltfiles x inner
join master .. sysdatabases s on s.dbid = x.dbid group
by s.name select
cast ( sum(dbsize)/1024 as varchar(20)) +space(1)+'GB' as overall_mass from @table