quick question about useage

Question

The database I am using is 10 dollars a month, but obviously no one can get a database to server a huge number of customers for ten dollars.  Is the "ConnectionPacks" the way that this is calculated?

For example, if I have many people using my website and say on average 10 connection are happening at a time, then is my charge only 10x$3.99 for the connection packs and then the data charge at 0.15 per gig, ten bucks for the database and that is it? 

 

Answer 1

The database I am using is 10 dollars a month, but obviously no one can get a database to server a huge number of customers for ten dollars.

SQL Azure throttles your use if you use long-running queries or otherwise hog resources. Otherwise, you get a 1GB database for $10 as the ad says.

 Is the "ConnectionPacks" the way that this is calculated?

Connection Packs are used with Azure AppFabric Service Bus and have nothing to do with SQL Azure.

Answer 2

Thanks Neil,

What I am trying to figure out now is what does it mean to hog resources?  If my site is not successful I wont have to worry about it.  But if it is, and so I have a lot of queries, would this mean I was "hogging" the resources? 

(I would be willing to pay for any resources used, if that is an option.)

 

Answer 3

Daniel,

if your site is succesful and the number of queries affects performance, you need to partition your data (and scale out). It's called sharding. Please have a look at http://social.technet.microsoft.com/wiki/contents/articles/how-to-shard-with-sql-azure.aspx

 

regards,

Riccardo

Answer 4

For your DB you need 1 GB DB 10$ + data charges Regards to connection Packs only apply if you use Azure AppFabric Service Bus.

---

K.Mohamed Faizal, Solution Architect, Singapore, @kmdfaizal
http://faizal-comeacross.blogspot.com/ |AzureUG.SG