HikariCP icon indicating copy to clipboard operation
HikariCP copied to clipboard

maxLifetime Configuration MSSQL Clarification

Open Warfront1 opened this issue 2 years ago • 0 comments

The README states the following in reference to maxLifetime: We strongly recommend setting this value, and it should be several seconds shorter than any database or infrastructure imposed connection time limit.

Which exact configuration fields should I be looking at, and how exactly do I access/view them? For example using another databse, MySQL, this is as easy as executing the following query SHOW VARIABLES like '%timeout%'; and looking at the wait_timeout field. What is the equivalent research process for MSSQL/TSQL?

For complete clarity I am using the following SQL Server Docker Image: mcr.microsoft.com/mssql/server:2019-CU15-ubuntu-20.04

Warfront1 avatar Aug 17 '22 18:08 Warfront1