Skip to Content
May 10 at 06:35 AM

Understanding the KeepAlive and KeepAliveInterval Parameters in SQL Server


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.