x

How is sys.servers query_timeout set?

For a production server sp_configure shows remote query timeout (s) 0 2147483647 600 600

however, sys.servers shows query_timeout of 15 seconds (not the 600 seconds from sp_configure). Why are these 2 settings different? How is sys.servers query_timeout set?

Thank you for your help
more ▼

asked Aug 10, 2011 at 06:58 AM in Default

Dan65804 gravatar image

Dan65804
11 1 1 2

(comments are locked)
10|1200 characters needed characters left

3 answers: sort newest

Great answers. In summary … Use SSMS to set server “remote query timeout”. Use sp_serveroption to override local “remote query timeout” in sys.servers

Thank you both.
more ▼

answered Aug 10, 2011 at 08:04 AM

Dan65804 gravatar image

Dan65804
11 1 1 2

(comments are locked)
10|1200 characters needed characters left

'remote query timeout' is the timeout for a remote operation on your server.

sys.servers lists the local and linked servers that have been configured, and the query_timeout column is the timeout specified for connections made through that linked server. Normally this is set at 0 which means use the remote servers default.

You would set this either through SSMS or sp_serveroption
more ▼

answered Aug 10, 2011 at 07:11 AM

Kev Riley gravatar image

Kev Riley ♦♦
53.3k 47 49 76

(comments are locked)
10|1200 characters needed characters left

Let's see if I'm keeping correctly track of the precedece. For a linked server:

[1]: http://msdn.microsoft.com/en-us/library/ms178532.aspx
more ▼

answered Aug 10, 2011 at 07:07 AM

Magnus Ahlkvist gravatar image

Magnus Ahlkvist
16.6k 17 20 33

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x87
x9
x5

asked: Aug 10, 2011 at 06:58 AM

Seen: 1633 times

Last Updated: Aug 10, 2011 at 07:03 AM