Tuesday, January 19, 2010

My SQL Azure Bill: Usage statistics like bandwidth and databases

Image credit: KevinSpencer

By using SQL Azure you do not have to be concerned about your backups, maintaince of your SQL Server, creating a fallback scenario etc. You only have to pay for what you are using. This is nice, but what are you using? You do not want to be suprised when the first bill is received. By using SQL Azure you need to pay for:
  1. Database usage. You will be invoiced for the number, type and duration of the database. Type of a database can be Business edition (Up to 10 Gb) or Web edition (Up to 1 Gb). Duration is the number of days the database was available on your SQL Azure server. 
  2. Bandwidth usage. You will be invoiced for inbound and outbound data traffic.
Within your database 2 views are available to get insight information about the Database usage and Bandwidth usage. I can imagine that these views are not so user friendly for your controller, I think he has even no access to these views. But you have at least something.

Database usage view: SELECT * FROM SYS.Database_usage. This view contains information about the number of database of eachtype you have everyday. One database for 30 days will be invoiced for the same amount as 30 databases one day.

Bandwidth usage view: SELECT * FROM SYS.Bandwidth_usage. This view contains the amount of bandwidth usage (in kilobytes KB) per database, per hour, data moving into SQL Azure, data moving out of SQL Azure, data from within Windows Azure and data from outside Windows Azure.

With these usage statistics you can calculate your bill for the coming month.
More detail about billing information can be found here. More details about the billing rates can be found here.
Enjoy using SQL Azure and hopefully you will not be badly suprised about the billing amount.


Deepa Psikologi said...

JavaScript lets you add interactive features to your Web sites, including dynamically updated content, controlled multimedia, animated images, and much more. Developed in partnership between W3C and University Côte d'Azur, this introductory course has been designed to help Web developers have an understanding of the basic concepts of the language.  best free microservice courses

unknown said...

Does it sense something new to you, because there are lots of students who really need the thesis writing services online because of shortage of subjective thesis, they preferred to take the risk first.

unknown said...

My SQL azure is the best topic for the student of the database those making the database so connect our service from the database. I am also working on the thing but for these reasons, I'm not covering the assignment taking online service from the cheap business law essay help this is one of the best writers in the UK.

issabella said...
This comment has been removed by the author.
issabella said...

My assignments were done by why crypto market crash
and they have delivered the best.

camdenarthur said...

Hello there! I came across your blog post about monitoring MySQL Azure usage statistics, and I found it to be very informative and helpful. As someone who works with databases, it's always great to learn about new tools and techniques for monitoring and optimizing performance.

However, I noticed that you briefly mentioned the concept of International Warehousing Services in one of your sections. As someone who has experience working in logistics and supply chain management, I found this to be an interesting topic to explore further.