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.

33 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

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

benji case said...

Nikmati diskon taruhan togel hanya di ludotogel

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

Adressa said...

Nikmati layanan pelanggan yang ramah dan profesional di Mpo303.

Adressa said...

Nikmati layanan pelanggan yang ramah dan profesional di Mpo303.

abiankeren48 said...

Take advantage of endless games with unbeatable promo bonuses and the most convenient mobile login available at the official link! Dutaslot

turacoz said...

thanks for this information
Medical Communications

Nuevos Techq Solutions said...

Informative...

Interesting points! What strategies do you use to manage and monitor your SQL Azure usage effectively to avoid unexpected costs? 🤔💡

Do you have an interest in Digital Marketing? If so, I'd like to share some stuff with you.
Visit🕸: https://nuevostech.com
https://nuevostech.com/about-us

Inner Wisdom Light said...

Thank you for the valuable information! This is so useful.
Please feel free to check out my website, Inner Wisdom Light (https://innerwisdomlight.com/), where we offer resources on fitness, yoga, meditation, and more to support a healthy and balanced lifestyle. Your feedback would be greatly appreciated!

Paiman Saefullah said...

This site is a fantastic resource. bandar toto macau.

Myron Yagnesh said...

Thank you for the valuable information! This is so useful.
Premium Open Plots for Sale in Digwal | Myron Homes.
Do Visit https://www.myronhomes.in/royal-crest/

Paiman Saefullah said...

The topics covered here are always so relevant mega888 apk.

Helda said...

The attention to detail on this site is mind-boggling—truly top-notch! mega888 apk

Adressa said...

Dapatkan pengalaman bermain slot online yang luar biasa dengan peluang menang besar setiap hari. slot online

brightinstitutemohali said...

thanks for sharing a valuable blog keep sharing.

Bank Po Coaching in Mohali from Bright Institute is a comprehensive and result-oriented course for students who want to crack various bank exams, such as SBI PO, IBPS PO, RBI Assistant, and more. The course covers the entire syllabus of bank exams, including Quantitative Aptitude, Reasoning, English, General Awareness, and Computer Knowledge.

Jason Roy said...

Understanding your My SQL Azure bill and usage statistics like bandwidth and databases, is essential for managing costs efficiently. Afnan 9.PM is key to managing your personal style.