SEDE database size

0

Please login or register to vote for this query.

(click on this box to dismiss)

total size used for all SEDE tables on current site

Stack Overflow

Q&A for professional and enthusiast programmers

select cast(round(((sum(a.used_pages) * 8)/1024.00/1024.00), 6) as numeric(36, 6)) as UsedSpaceGB
from sys.tables t
  inner join sys.indexes i on t.object_id = i.object_id
  inner join sys.partitions p on i.object_id = p.object_id and i.index_id = p.index_id
  inner join sys.allocation_units a on p.partition_id = a.container_id
  left outer join sys.schemas s on t.schema_id = s.schema_id
where t.name not like 'dt%' and t.is_ms_shipped=0 and i.object_id>255

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results