Attribute

SocketIdleTimeCheckInterval (SITCI)

Purpose

Specifies the interval of time, in seconds, at which the driver checks the connection for activity when Keep Connection Active is enabled (KeepConnectionActive=1). If no activity has been detected during this period, the driver issues a lightweight query (Select 0) to the database to maintain the connection. This functionality provides a method to keep open connections to data sources that use Azure SQL Gateway, such as Azure SQL Database and Azure Synapse Analytics, during periods of inactivity.

Valid Values

x

where:

x
is the interval of time, in seconds, at which the driver checks the connection for activity.

Default

1500 (seconds)

GUI Tab

Advanced tab

See Also