Skip to Content
author's profile photo SAP Support
0
SAP Support
May 10 at 06:35 AM

Understanding the KeepAlive and KeepAliveInterval Parameters in SQL Server

100 Views

I want to increase the TCP Keepalive duration in my SQL Server.
Currently, the setting is dbs/mss/conn_opts = KeepAlive=30;KeepAliveInterval=12.
If I change it to dbs/mss/conn_opts = KeepAlive=120;KeepAliveInterval=20, how will the behavior change?


------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.