SQL Server Performance Forum – Threads Archive
Connection timeout settingHi 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?
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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.