SQL Azure Billing Numbers Directly From Transact-SQL

Thanks to Karlo Bartels‘s comment on my previous post, here a detailed blogpost on Microsoft.com about the SQL Azure billing numbers/costs with the use of Dynamic Managed Views.

SQL Azure exposes two Dynamic Managed Views called sys.database_usage and sys.bandwidth_usage that show you the activity for your account. These can queried to understand your account usage from a billing perspective.

Database storage costs:

Bandwidth costs:

Download the code right here.

Thanks to Wayne Walter Berry and his post.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s