Free Trial *Internet Service Required
Windows Azure Platform > Windows Azure Forums > SQL Azure > What type of performance is guaranteed with SQL Azure?

Answered What type of performance is guaranteed with SQL Azure?

    •  
      Thursday, October 22, 2009 1:27 PM
       
       
      Sign In to Vote
      0
      Sign In to Vote
      Does a database instance with 10 GB does not require compute power. What type of performance is guaranteed with SQL Azure?
      Murty Eranki
       

    Answers

    • Saturday, October 24, 2009 3:42 PM
       
       Answered
      Sign In to Vote
      0
      Sign In to Vote
      Murty:

      We currently do not provide a performance SLA for SQL Azure although this is something that we are looking into. 

      Although we run on "commodity hardware" in the data center, it is pretty powerful and the throughput and response rate for most customers has been very good.  As mentioned on another thread, we continue to refine our throttling mechanisms to make sure we are providing the highest level of performance while still being fair across tenants and protecting the health of the overall system.  This is a delicate balancing act and I'm sure we'll continue to refine this based on feedback from customers for some time to come.

      Early adopters have also found that SQL Azure allows them to provide a data tier to their applications that leverages scale-out - of relational storage and query processing.  For certain applications, this can have dramatic effects as you harness the power of 10's of CPUs in parallel to service the needs of your app.  For an internal partner running on this same infrastructure they were able to take end user queries down from 10's of minutes to 10's of seconds - quite dramatic for that app.

      Would appreciate any feedback you or others have on the types of performance and capacity guarantees you'd like to see in future versions of the service.  Please respond to the "sticky" thread for feedback above or drop me a note at patricmc AT microsoft DOT com.

      Patric
       

    All Replies

    • Saturday, October 24, 2009 3:42 PM
       
       Answered
      Sign In to Vote
      0
      Sign In to Vote
      Murty:

      We currently do not provide a performance SLA for SQL Azure although this is something that we are looking into. 

      Although we run on "commodity hardware" in the data center, it is pretty powerful and the throughput and response rate for most customers has been very good.  As mentioned on another thread, we continue to refine our throttling mechanisms to make sure we are providing the highest level of performance while still being fair across tenants and protecting the health of the overall system.  This is a delicate balancing act and I'm sure we'll continue to refine this based on feedback from customers for some time to come.

      Early adopters have also found that SQL Azure allows them to provide a data tier to their applications that leverages scale-out - of relational storage and query processing.  For certain applications, this can have dramatic effects as you harness the power of 10's of CPUs in parallel to service the needs of your app.  For an internal partner running on this same infrastructure they were able to take end user queries down from 10's of minutes to 10's of seconds - quite dramatic for that app.

      Would appreciate any feedback you or others have on the types of performance and capacity guarantees you'd like to see in future versions of the service.  Please respond to the "sticky" thread for feedback above or drop me a note at patricmc AT microsoft DOT com.

      Patric
       
    • Sunday, October 25, 2009 5:06 AM
       
       
      Sign In to Vote
      0
      Sign In to Vote
      Patric:

      Thanks for your time and for the response. This is with reference to one solution proposal using Microsoft Cloud, where we have response time SLA's for our applicaitons. So we definitely need same from different components of the Microsoft Cloud. Otherwise we need to plan our architecture to take care of that. I want to understand how this can be done and is there some metrics/data you can share to public what kind of performance that you are able to provide to currently hosted applicaitons and what factors may degrade / upgrade the performance of applications with SQL Azure. I would like to connect with you and provide our wish list and some feedback on your email.
      Murty Eranki