From the CTO of RADSense Software

Alin Irimie

Subscribe to Alin Irimie: eMailAlertsEmail Alerts
Get Alin Irimie via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

Related Topics: Cloud Computing, Data Services Journal, Azure Cloud on Ulitzer, Microsoft Developer, CIO/CTO Update

Blog Feed Post

SQL Azure Database Size Calculator

Ryan Dunn, the Technical Evangelist for Windows Azure, posted a neat trick on how to measure your database size in SQL Azure.  Here is the exact queries you can run to do it:

sum(reserved_page_count) * 8.0 / 1024

sys.objects.name, sum(reserved_page_count) * 8.0 / 1024
sys.dm_db_partition_stats, sys.objects
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.

Related posts:

Read the original blog entry...

More Stories By Alin Irimie

Alin Irimie is a software engineer - architect, designer, and developer with over 10 years experience in various languages and technologies. Currently he is Messaging Security Manager at Sunbelt Software, a security company. He is also the CTO of RADSense Software, a software consulting company. He has expertise in Microsoft technologies such as .NET Framework, ASP.NET, AJAX, SQL Server, C#, C++, Ruby On Rails, Cloud computing (Amazon and Windows Azure),and he also blogs about cloud technologies here.