Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

How to: Configure the query wait Option (SQL Server Management Studio)

Use the query wait option to specify the time in seconds (from 0 through 2147483647) that a query waits for resources before timing out. If the default value of -1 is used, or if –1 is specified, then the time-out is calculated as 25 times the estimated query cost.

To configure the query wait option

  1. In Object Explorer, right-click a server and select Properties.

  2. Click the Advanced node.

  3. Under Parallelism, type the desired value for the query wait option.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.