Yesterday we looked at how you could determine the cost of a single row stored in SQL Azure. Part of my focus for doing so was to help you understand that a bad database design can lead to higher costs. Creating unnecessarily wide tables will result in more storage which then results in a higher cost. You [...]
SQLServerPedia Wiki
March Madness – SQL Azure – sys.dm_db_partition_stats – Row Cost
Yesterday we talked about how you could find the size of your database, and the size of objects inside of your database. Today we are going to go one level deeper and look at the sizes of rows inside of SQL Azure. We will be using systems views that have already been covered previously in [...]
March Madness – SQL Azure – sys.dm_db_partition_stats
The past two days we talked about the billing aspects of SQL Azure and how to get an estimate of your charges. Today we will shift our focus a bit and talk about size. Since you pay for storage with SQL Azure it would be a good thing to know a bit more details about [...]
March Madness – SQL Azure – sys.bandwidth_usage
Yesterday we talked about one aspect of SQL Azure pricing but it was only tied to database usage. Today we will talk about the other piece of SQL Azure costs: pushing and pulling data to SQL Azure. The dirty details can be found inside the sys.bandwidth_usage system view:
SELECT *
FROM sys.bandwidth_usage
Go ahead and run the above [...]