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.

See Also