Witch solution to choose? Azure?

Question

Hey.

I have an application where students will logon many users at the same time. So then the sql database needs to support many simultaniously connections at the same time. at most 1000. This is basically the only thing i need.

What will be a good solution to choose.

Regards Vegaredo

Answer 1

Hi,

There is no max number of concurrent connections on SQL Azure but you should implement the retry logic.

Take a look at SQL Azure connection constraint at http://msdn.microsoft.com/en-us/library/ee336245.aspx#cc

---

If you found this post useful, Please "Mark as Answer" or "Vote as Helpful". Best Regards.

Answer 2

Alright, but what plan solution is best for my needs?

What will the monthly cost be?

Regards

Answer 3

In SQL Azure you only pay for used space, you will be billed based on the database size.

Please take a look at Pricing and Metering for SQL Azure Database at http://www.windowsazure.com/en-us/home/features/sql-azure/

You can choose the max database size and by doing so limit the maximum bill at the end of the month.

You can also use the free 90 day trial and be entitled to use 1GB web edition SQL Azure database for free.

---

If you found this post useful, Please "Mark as Answer" or "Vote as Helpful". Best Regards.

Answer 4

Okey sounds good.

2 questions though.

Can i only host the database in this solution or do i have to have other things also?

What will be the price for hosting only 1 database?

Size of the database is rather small. We are talking MB.

Regards

Answer 5

You can just host 1 the database without any other services.

Quick step guide:

1 - Register for Windows Azure (free trial or pay as you go)

2- In the Windows Azure Management Portal, go to the Database and create a Server (you need to open the firewall for some IP addresses, all IP are blocked by default)

3 - Create the database

4 - Use SQL Azure Management Portal to manage the database

Pricing as refered before:

Database Size	Price Per Database Per Month
0 to 100 MB	Flat $4.995
Greater than 100 MB to 1 GB	Flat $9.99

Take a look at http://www.windowsazure.com/en-us/home/features/sql-azure/

---

If you found this post useful, Please "Mark as Answer" or "Vote as Helpful". Best Regards.