Number of sites and databases per Azure account RRS feed

  • Question

  • We have decided to look into this, and I have two questions as stated in the title.

    I had searched for dicussions regarding both, and have found articles of how to create multiple sites per role, and also using multiple databases.

    I just want to confirm that. I create an Azure account, am I then limited to one site and one database? Or can I have multiples of both?

    Am I correct in understanding that I actuall get an 'IIS' equivalent and a 'SQL Server' equivalent where I can create multiple sites and databases?

    Thanks in advance.



    Wednesday, July 27, 2011 10:20 AM


All replies

  • You can have multiple sites and SQL Azure databases in your Windows Azure subscription.  You can actually host multiple sites in a single web role.  If you haven't already, check out the "Usage Quotas" section at http://www.microsoft.com/windowsazure/offers/popup/popup.aspx?lang=en&locale=en-us&offer=MS-AZR-0003P for a breakdown on the quotas.

    With a Windows Azure web role, you have the IIS7/7.5 stack available for you web applications.  Remember that Windows Azure is based on Windows Server 2008 (or R2, your choice).  If you can run it it on Windows Server 2008, you can typically run it on Windows Azure.

    SQL Azure is mostly like SQL Server 2008.  There are some things that are not supported in SQL Azure.  For a list, please see http://social.technet.microsoft.com/wiki/contents/articles/sql-azure-delivery-guide.aspx#SQL_Server_Features_Not_Included_in_SQL_Azure and also http://msdn.microsoft.com/en-us/library/ff394102.aspx.


    • Proposed as answer by BrentDaCodeMonkey Wednesday, July 27, 2011 2:06 PM
    • Marked as answer by paulnerie Thursday, July 28, 2011 1:26 AM
    Wednesday, July 27, 2011 12:42 PM
  • The only thing I'd add to what Michael has said is that there are some default limits imposed on the number of hosted services, storage accounts, etc.... These limits can be raised but you will need to contact Microsoft and complete a credit check. The default limits are just what MSFT feels they can safely get by with on a simple credit card swipe. So if you're going to exceed those limits, they want to make sure you're able to pay the bill. :)
    Wednesday, July 27, 2011 2:08 PM
  • Thanks you both for your replies. I have been reading the documentations and pricing schemes, I just want to confirm that what I understand is correct :).

    So it's similar to getting one of those dedicated servers in terms of use (IIS and DB server), only with limits.

    Thursday, July 28, 2011 1:29 AM
  • It's not exactly like getting a dedicated server.  SQL Azure is similar to SQL Server 2008, but there are feature and functional differences.  I would encourage you to understand those differences before going to down a path and finding something that causes you some late nights.  :)
    Thursday, July 28, 2011 3:03 AM