Specs of SQL Azure VM?


  • I would like to know the specifications of the VM that an SQL Azure instance is running on. I can find the specs of a windows azure VM: 1 core + 1.5 gig mem for a small instance. A medium size instance has 2 cores, and 3 gig memory.

    But how is this for SQL Azure? And how can I set which size I want?

    Thank you in advance.
    Thursday, December 24, 2009 7:21 AM


  • Hi Bert, SQL Azure is not set up around the classic VM approach. I am grossly oversimplifying here but the basic setup in SQL Azure is this; each database occupies multiple nodes through a single primary database that processes your queries and two secondary copies that provide HA (and the guaranteed %99.9 SLA). If the primary fails for any reason, secondary copies pick up immediately and carry on. When it comes to computational capacity; SQL Azure cluster contain 100s of nodes that provides massive scale. Each node serves many tenants. Through load balancing and throttling mechanisms we keep the clustered balanced.

    If you'd like more details, Jeff's under the hood talk explains the architecture in detail;




    Sunday, December 27, 2009 1:15 AM