Azure SQL Connectivity Performance Tips & Tricks

The Discussion

• 

  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?
  

• 

  @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!