SQL Azure Database Size Calculator

Posted by kaleidoscope on Geeks with Blogs See other posts from Geeks with Blogs or by kaleidoscope
Published on Mon, 22 Mar 2010 04:45:59 GMT Indexed on 2010/03/22 6:01 UTC
Read the original article Hit count: 306

Filed under:

A neat trick on how to measure your database size in SQL Azure.  Here are the exact queries you can run to do it:

Select
Sum (reserved_page_count) * 8.0 / 1024
From
sys.dm_db_partition_stats
GO

Select
sys.objects.name, sum (reserved_page_count) * 8.0 / 1024
From
sys.dm_db_partition_stats, sys.objects
Where
sys.dm_db_partition_stats.object_id = sys.objects.object_id
Group by sys.objects.name

The first one will give you the size of your database in MB and the second one will do the same, but break it out for each object in your database.

http://www.azurejournal.com/2010/03/sql-azure-database-size-calculator/

 

Ritesh, D

© Geeks with Blogs or respective owner