Connection pooling is one of the best practices that we could implement in our code due to improvement in the time spent establishing the connection. However, if we are not aware about it, we may have connectivity issues that may not be related with database service and may be related how our application closes the connection in case of any error, error handling or server client infraestructure level.
In this YouTube session(below) we reviewed three important points when the connection pooling is enabled:
- The impact establishing the connection time spent to our Azure SQL database/server.
- What is the reason about a typical error when we reached the maximum limit of the connection pooling - Timeout period elapsed prior to obtaining a connection from the pool.
- How to obtain connectivity pooling metrics to know how many connections, many connections pool, etc..

Video provider requires cookies to play the video. Accept to continue or watch it directly on the provider's site.
Enjoy!
Updated Feb 23, 2023
Version 5.0Jose_Manuel_Jurado
Microsoft
Joined November 29, 2018
Azure Database Support Blog
Follow this blog board to get notified when there's new activity