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 😉
braju (9/24/2012)
Please note that the SQL server is in VM environment on 32 bit OS server.Thanks
Which version and edition of the Windows OS?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉