patternsqlMinor
Does SQL Server query timeout settings change require a server restart?
Viewed 0 times
settingsrestartsqlquerytimeoutdoesrequireserverchange
Problem
I'm trying to execute a query that times out after 10 minutes. From experience I know that the query takes about 18 minutes to execute. It's not ideal, and this is being worked on, however for now I just need it to execute.
Having changed the
This is using SSMS on a remote computer. Why is the timeout setting not taking effect? Do I need to restart the server? (This isn't possible right now)
Having changed the
Remote query timeout parameter to 0, however, the query is STILL timing out after 10 minutes. I get the message:The statement has been terminated.
Msg -2, Level 11, State 0, Line 16
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.This is using SSMS on a remote computer. Why is the timeout setting not taking effect? Do I need to restart the server? (This isn't possible right now)
Solution
According MS-DOCS you don't need to restart SQL Server.
Configure the remote query timeout Server Configuration Option
Follow Up: After you configure the remote query timeout option
The setting takes effect immediately without restarting the server.
Configure the remote query timeout Server Configuration Option
Follow Up: After you configure the remote query timeout option
The setting takes effect immediately without restarting the server.
Context
StackExchange Database Administrators Q#181594, answer score: 6
Revisions (0)
No revisions yet.