SQL Server Remote Query Timeout Setting

Remote query timeout server configuration option in SQL Server specifies how much time in seconds will SQL Server wait for a remote query of an outgoing connection before it times out. It has no effect on incoming queries issued by clients connected to SQL Server. Query timeout is a client-side setting. An example is a query to a linked server, in which case our SQL Server becomes a client to another server.

The default value for this setting is 600 seconds. You can check the current Remote query timeout setting by running:

sp_configure 'remote query timeout (s)'

To change the value for the Remote query timeout setting (for example to 900 seconds):

EXEC sp_configure 'remote query timeout', 900;
GO
RECONFIGURE ;
GO

To disable the timeout, set the value to 0:

EXEC sp_configure 'remote query timeout', 0;
GO
RECONFIGURE;
GO

You can check and change the current setting by right-clicking on the instance name in Object explorer in SQL Server Management Studio, and selecting Properties, and Connections:

This setting is located just below the checkbox that allows remote connections to the server. It is important to be aware that the remote query timeout value below is not a timeout setting for incoming connections to the server. Clients need to set the query timeout in their connection setting.

If the post helped you, please share it:
Pin It

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">