Perry Whittle (9/24/2012)
braju (9/24/2012)
From what I have seen as reponses, I think we should set the MAXDOP to default to 0 and adjust cost threshold of parallelism if needed or even ahve MAXDOP query hint inside a specific SQL processing. At the same time fine tune the SQL queries that might cause the bottlenecks.That's what i said above 😉
That's funny because I thought the same thing when I read your initial post 😀
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato