Steps to reproduce:
- In place by default from time to time
- Monitored via ODBC SQL gets timeouts restored in the next 30-60 seconds
- Most probably increasing the timeout value will help to get rid of this issue
- Maybe additional improvements like ability to provide frequent queries might be helpful too.
Result:
600701:20231009:045104.498 item "SQL1:mssql.db.log_flush_waits_sec.rate["SomeDatabase"]" became not supported: Cannot connect to ODBC DSN: [SQL_ERROR]:[HYT00][0][[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired]|[08001][258][[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Timeout error [258]. ]|[08001][258][[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Unable to complete login process due to delay in prelogin response]
Expected:
Increase default SQL timeout parameters:
|