locked
SQL Azure Max Connections RRS feed

  • Question

  • Question #1:

    What is the maximum number of concurrent connections in SQL Azure?

     

    Question #2:

    What is the maximum connection pool size for SQL Azure?

     

    Question #3:

    Do questions #1 and #2 have a direct correlation?  Meaning (for example) if the maximum connection pool size is 100...is the maximum number of concurrent connections 100?

     

    All the best,

     

    John

     

     

    Tuesday, June 22, 2010 2:16 PM

Answers

  • Hi John,
    There is no maximum number of concurrent connections on SQL Azure Server defined. In theory it depends on hardware and OS capability. Connection pool is a client side conception, you can define its size in your client application.

    I recommend that you use connection pool to connect to your SQL Azure server. In your application, if you set your connection pool's size to 100, it means that concurrently you can have maximum 100 concurrent connections, but if you encounter bottleneck on the connections, you can increase your connection pool's size. Here are some articles for your reference:
    Connection Constraints
    http://msdn.microsoft.com/en-us/library/ee336245.aspx#cc
    Connection Pooling (ADO.NET)
    http://msdn.microsoft.com/en-us/library/bb399543.aspx


    Please remember to mark the replies as answers if they help and unmark them if they provide no help
    Wednesday, June 23, 2010 9:15 AM