Windows Azure Platform >
> 
> 
Witch solution to choose? Azure?

Answered Witch solution to choose? Azure?

  • Monday, May 07, 2012 8:24 PM
     
     
    Sign In to Vote
    0

    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

     

All Replies

  • Monday, May 07, 2012 9:09 PM
     
     
    Sign In to Vote
    0

    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.

     
  • Monday, May 07, 2012 9:21 PM
     
     
    Sign In to Vote
    0

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

    What will the monthly cost be?

    Regards

     
  • Monday, May 07, 2012 9:58 PM
     
     
    Sign In to Vote
    0
    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.

     
  • Monday, May 07, 2012 10:03 PM
     
     
    Sign In to Vote
    0

    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

     
  • Monday, May 07, 2012 10:19 PM
     
     Answered
    Sign In to Vote
    0

    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.