Want to work with us? We're on the lookout for a Magento Developer.

We're hiring

SQL Server Code to Find Total Size of Database

Web Bureau

02 February 2012 by Web Bureau

Total database size script


[SpaceUsed(KB)] = SUM(alloc.used_pages)*8

FROM sys.objects obj

JOIN sys.indexes idx on obj.object_id = idx.object_id

JOIN sys.partitions prt on obj.object_id = prt.object_id

JOIN sys.allocation_units alloc on alloc.container_id = prt.partition_id


obj.type = 'U' AND idx.index_id IN (0, 1)

Grow your businessStart a project with us today.