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
In Object Explorer, right-click a server and select Properties.
Click the Advanced node.
Under Parallelism, type the desired value for the query wait option.