November 19, 2010 at 5:10 am
I have an instance (SQL SERVER 2008) running multiple OLTP systems. The max degree of parallelism is set to 1. Now I need to rebuilt some indexes and tried specifying the MAXDOP=4 (there are 8 cores on the server) however the rebuilt is only using one core. I've tried changing it to 2 or 6 but still no success! What can be the problem since the MAXDOP should overwrite the max degree of parallelism setting?
Regards
Brian
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
November 19, 2010 at 5:20 am
What edition of SQL Server are you using? Straight out of Books On Line - "Parallel index operations are available only in SQL Server Enterprise, Developer, and Evaluation editions."
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
November 19, 2010 at 5:26 am
Nakul Vachhrajani (11/19/2010)
What edition of SQL Server are you using? Straight out of Books On Line - "Parallel index operations are available only in SQL Server Enterprise, Developer, and Evaluation editions."
Sorry forgot to mention... SQL Enterprise Edition 64bit
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
November 19, 2010 at 5:48 am
Can you confirm if the SQL Server is configured to use all processors (CPU affinity)?
Also, depending upon the query and the load, SQL Server can choose not to use the specified number of processors.
I am leaving for the day, but may check back in later today or tomorrow.
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
November 19, 2010 at 5:54 am
Nakul Vachhrajani (11/19/2010)
Can you confirm if the SQL Server is configured to use all processors (CPU affinity)?Also, depending upon the query and the load, SQL Server can choose not to use the specified number of processors.
I am leaving for the day, but may check back in later today or tomorrow.
Yes it is, all processors are checked. I thought that for an index rebuild, the engine will always use the max processors.
Thanks
Brian
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply