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.

30 comments:

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.

Michael Findley said...

Every University student is looking source which is simple, unique and fast service. Best Assignment Help They provide excellent service and timely delivery of high-quality work. The costs are fair, and the staff is competent. They have been helpful to me, and I will keep using their services.

Brick N Walls said...

One of the key highlights of Eldeco La Vida Bella is its strategic location in Sector 12, Noida Extension

jojiboi said...

Join the winning community at login olxtoto and experience gaming like never before. login olxtoto

Adressa said...

Kimtoto Your website has helped me develop a deeper understanding of myself and others.

Adressa said...

Your website has shown me that success is not just about achieving goals but also about finding fulfillment and happiness. Kimtoto

Adressa said...

Navigating through your website is a seamless and enriching experience, thanks to its intuitive layout and insightful articles. Markaszeus

Harif said...

Nikmati sensasi taruhan yang autentik dan mendebarkan dengan bermain di situs toto terpercaya. situs toto

Darsa said...

Temukan kesempatan emas untuk menghasilkan uang tambahan dengan Situs IDN Pokercapsa Online 2024. Situs IDN Pokercapsa Online 2024

Harif said...

Jelajahi fitur-fitur unggulan di situs slot Hebohtoto yang memastikan pengalaman taruhan yang memuaskan. situs slot hebohtoto

oktavian said...

Kudos to them for their detailed assistance with SKP, K3 licenses, and SIO renewals. Their insistence on renewing prior to the 1-year deadline and the assurance of lifelong validity for Kemnaker certificates are highly appreciated. jasa perpanjangan lisensi

oktavian said...

Join the community where excitement reaches new heights. Maxwin is simple to achieve on this top-tier site, which offers the highest RTP options, phenomenal bonuses, and swift service. Use one account to explore a vast selection of games! SITUS SLOT TERPERCAYA

Harif said...

Agen X500 adalah pilihan terbaik untuk permainan slot online yang menguntungkan agen x500

Adressa said...

Website topup game murah dengan harga terjangkau dan proses mudah website topup game murah

Darsa said...

master198 menawarkan slot dengan berbagai fitur bonus

oktavian said...

Playing slots here is always a fun and thrilling experience! Keeping an optimistic outlook makes every game more exciting, making it the best place to play. ludo togel

benji case said...

Nikmati diskon taruhan togel hanya di ludotogel

oktavian said...

Hands down, the best site! Their 24-hour full service and top RTP ensure VIP members are always satisfied and pampered with rewards. Superb! king198

abiankeren48 said...

After trying many different sites, I can confidently say that this one offers the most hope and substantial opportunities for significant earnings. It's a standout in the gaming community. empiretoto

caesar pratama19 said...

Designed with the user in mind, our website offers an intuitive and enjoyable browsing experience, supported by reliable performance and rich, engaging content Hokislot

Adressa said...

Nikmati layanan pelanggan yang ramah dan profesional di Mpo303.

Adressa said...

Nikmati layanan pelanggan yang ramah dan profesional di Mpo303.

caesar pratama19 said...

A premier online destination offering insightful content and seamless user experience for a global audience 4d slot

caesar pratama19 said...

Delivering top-notch articles and multimedia, this website sets the standard for quality and reliability X500 Slot

caesar pratama19 said...

An innovative platform combining comprehensive information and intuitive design for an unmatched user journey Sbobet88