Connection timeout setting | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Connection timeout setting

Hi there, Couldnt use the search feature in the forums properly so im asking a simple question hopefully. What is the default connection timeout limit in SQL Server? Or is there one? And if so, where can i configure it? Thanks in advance.
There is no option in SQL Server for connection timeout.
When you have connection timeout?
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
Well, for example if i have an application that connects to the SQL server but for some bug or poorly designed feature, it doesnt close it connection once its done. Does that mean that connection will stay there indefinitely until i manually kill it or restart SQL server?
SQL server will not drop any of its connection until unless client application guides so or when the SQL services are refreshed. Refer to this threadhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=5869 for using the script to kill those idle connections on the SQL Server. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>