locked
Questions on SQL Database & SQL Server RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Can someone from MS answer the following?

    - What are the software (OS and SQL Server versions) and hardware (CPU & RAM) specifications of the P1, P2, and P3 offerings?

    - Are P1, P2, and P3 hosted in dedicated servers or shared servers?

    - What is the maximum amount of storage that can be attached to a SQL Server VM (assuming it's Enterprise edition)?

    - What is the SLA for data durability in P1, P2, and P3 as well as SQL Server VM? Will some objects be lost eventually? 

    Tuesday, May 20, 2014 4:06 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks for the feedback. 

    You've mixed up a set of questions about SQL Database, which I can answer with a set of SQL Server in a VM questions which I'm not the right contact to answer.  These are also different forums.

    Let me take the SQL Database questions.

    The premium service tier, are dedicated resources that are not shared with another customer.  The way to think about this is a dedicated computer with a set of CPU, Memory, IO resources.  We refer to that collection of resources as DTUs.  A great MSDN article on DTUs is here http://msdn.microsoft.com/en-us/library/azure/dn369873.aspx

    There are many reasons why we don't talk directly about the HW resources.  One of which is that we have mutiple versions of DC hardware in use at any specific point in time.  Another is that we know from customer feedback that not all of these resources are well understood.  While CPU/cores is better understood, IOPS which is super important for a database system are not well understood.  The new Basic/Standard/premium SQL Database tiers allow customers to use the portal to understand their historical resource consumption.  Again that MSDN article above is a great start.

    Premium (P1, P2, P3) are in public preview today.  When they GA, they will then have a 99.95 availability SLA.  It's too early to set a GA timeframe.

    My apologies that I can't answer the SQL Server VM questions.

    Tuesday, May 20, 2014 6:12 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Re: your question on max amount of storage that can be attached to SQL Server VM, it's no different than the WA VM limits. For e.g., for A4, it's 16X 1TB disks. You can find full documentation below:

    http://msdn.microsoft.com/library/azure/dn197896.aspx

    Hope this helps.

    Wednesday, May 21, 2014 9:58 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks for the feedback. 

    You've mixed up a set of questions about SQL Database, which I can answer with a set of SQL Server in a VM questions which I'm not the right contact to answer.  These are also different forums.

    Let me take the SQL Database questions.

    The premium service tier, are dedicated resources that are not shared with another customer.  The way to think about this is a dedicated computer with a set of CPU, Memory, IO resources.  We refer to that collection of resources as DTUs.  A great MSDN article on DTUs is here http://msdn.microsoft.com/en-us/library/azure/dn369873.aspx

    There are many reasons why we don't talk directly about the HW resources.  One of which is that we have mutiple versions of DC hardware in use at any specific point in time.  Another is that we know from customer feedback that not all of these resources are well understood.  While CPU/cores is better understood, IOPS which is super important for a database system are not well understood.  The new Basic/Standard/premium SQL Database tiers allow customers to use the portal to understand their historical resource consumption.  Again that MSDN article above is a great start.

    Premium (P1, P2, P3) are in public preview today.  When they GA, they will then have a 99.95 availability SLA.  It's too early to set a GA timeframe.

    My apologies that I can't answer the SQL Server VM questions.

    Tuesday, May 20, 2014 6:12 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Re: your question on max amount of storage that can be attached to SQL Server VM, it's no different than the WA VM limits. For e.g., for A4, it's 16X 1TB disks. You can find full documentation below:

    http://msdn.microsoft.com/library/azure/dn197896.aspx

    Hope this helps.

    Wednesday, May 21, 2014 9:58 PM