HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Does SQL Server query timeout settings change require a server restart?

Submitted by: @import:stackexchange-dba··
0
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 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.

Context

StackExchange Database Administrators Q#181594, answer score: 6

Revisions (0)

No revisions yet.