Build with an Azure free account. Get USD200 credit for 30 days and 12 months of free services.

Start free today

Azure SQL Connectivity Performance Tips & Tricks

Play Azure SQL Connectivity Performance Tips & Tricks

The Discussion

  • User profile image
    Amy

    Hi, Thanks for the video. Regarding Connection pooling do you recommend changing "Max Pool Size" with default value 100. For example, S2 supports 120 supports max concurrent requests?

  • User profile image
    Scoriani
    @Amy:Hi Amy, generally speaking i wouldn't recommend changing defaults for connection pooling. Client drivers are quite smart in keeping number of active connections in the pool at the minimum dynamically. I'd rather recommend making sure your connections are properly managed: opened when it's needed and released to the pool as soon as database commands are executed and results are consumed. Doing this, pooling will never be an issue!

Add Your 2 Cents