July 10, 2014 at 10:51 pm
Hi ,
How does SQL server decide maxdop setting in UPDATE STATS and SP_UPDATESTATS. I see MAXDOP=1 being used when updating stats using sp_updatestats. I suspect this setting can be causing my stats update to be slow.
config_value of maxdop has been set to 8 as per Microsoft recommendation
http://support.microsoft.com/kb/2806535
Cheers
July 11, 2014 at 3:41 am
For the most part updating statistics runs in a similar fashion to any other query in the system. The degree of parallelism is set at the system level and SQL Server will use that when running the queries. There's nothing in sp_updatestats that forces MAXDOP 1. You can't force MAXDOP on UPDATE STATISTICS through a hint (although there is an open Connect item requesting that). If you're on Enterprise you can force this through the Resource Governor.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply