Lesson Learned #155: Timeout period elapsed prior to obtaining a connection from the pool.

Published Dec 11 2020 01:03 PM 1,357 Views

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 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.. 

Enjoy!

%3CLINGO-SUB%20id%3D%22lingo-sub-1981163%22%20slang%3D%22en-US%22%3ELesson%20Learned%20%23155%3A%20Timeout%20period%20elapsed%20prior%20to%20obtaining%20a%20connection%20from%20the%20pool.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1981163%22%20slang%3D%22en-US%22%3E%3CP%3EConnection%20pooling%20is%20one%20of%20the%20best%20practices%20that%20we%20could%20implement%20in%20our%20code%20due%20to%20improvement%20in%20the%20time%20spent%20establishing%20the%20connection.%20However%2C%20if%20we%20are%20not%20aware%20about%20it%2C%20we%20may%20have%20connectivity%20issues%20that%20may%20not%20be%20related%20with%20database%20service%20and%20may%20be%20related%20how%20our%20application%20closes%20the%20connection%20in%20case%20of%20any%20error%2C%20error%20handling%20or%20server%20client%20infraestructure%20level.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20this%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DCMomjxJsGGI%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EYouTube%20session%3C%2FA%3E%20we%20reviewed%20three%20important%20points%20when%20the%20connection%20pooling%20is%20enabled%3A%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EThe%20impact%20establishing%20the%20connection%20time%20spent%20to%20our%20Azure%20SQL%20database%2Fserver.%3C%2FLI%3E%0A%3CLI%3EWhat%20is%20the%20reason%20about%20a%20typical%20error%20when%20we%20reached%20the%20maximum%20limit%20of%20the%20connection%20pooling%20-%26nbsp%3BTimeout%20period%20elapsed%20prior%20to%20obtaining%20a%20connection%20from%20the%20pool.%3C%2FLI%3E%0A%3CLI%3EHow%20to%20obtain%20connectivity%20pooling%20metrics%20to%20know%20how%20many%20connections%2C%20many%20connections%20pool%2C%20etc..%26nbsp%3B%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EEnjoy!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1981163%22%20slang%3D%22en-US%22%3E%3CP%3EConnection%20pooling%20is%20one%20of%20the%20best%20practices%20that%20we%20could%20implement%20in%20our%20code%20due%20to%20the%20improvement%20in%20the%20time%20spent%20establishing%20the%20connection.%20However%2C%20if%20we%20are%20not%20aware%20about%20it%2C%20we%20may%20have%20connectivity%20issues%20that%20may%20not%20be%20related%20with%20database%20service%20and%20may%20be%20related%20how%20our%20application%20closes%20the%20connection%20in%20case%20of%20any%20error%2C%20error%20handling%20or%20server%20client%20infraestructure%20level.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Version history
Last update:
‎Dec 11 2020 01:12 PM
Updated by: