Viewing 4 posts - 1 through 4 (of 4 total)
Good responses. Thanks so much for giving all the inputs. I thought I would go ahead with setting the MAXDOP = 0 the default value and then adjust...
September 24, 2012 at 1:29 pm
Windows OS - Win 2003 SP2 Enterprise Edition
SQL Server - 2005 Standard Edition.
Our client is plaaning to move onto 64 bit envoronment but still keep the servers in VM.
Thanks
September 24, 2012 at 8:13 am
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...
September 24, 2012 at 7:11 am
Well, it was set to default one time, but we experienced some timeouts, further investigating the cause of the timeouts, we saw some OLTP processing such as Search stored procedures...
September 24, 2012 at 6:18 am
Viewing 4 posts - 1 through 4 (of 4 total)