December 10, 2003 at 6:24 pm
I need to keep our 4 processor machine running smoothly. Several statisticians run queries with lots of parallelism causing the system to hang so I turned off parallelism at the server level. What takes precedence?
sp_configure or (MAXDOP x)?
December 11, 2003 at 10:15 am
I believe that they are two views into the same setting.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 11, 2003 at 10:28 am
If sp_configure 'max degree of parallelism', 1 is set, will a query with MAXDOP 4 override the server setting?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply