What is the maximum number of concurrent connections in SQL Azure?
What is the maximum connection pool size for SQL Azure?
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,
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 Pooling (ADO.NET)
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?