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: 338
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/
© Geeks with Blogs or respective owner