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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy