Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Degree of parallelism in SQL Server

    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...

  • RE: Degree of parallelism in SQL Server

    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

  • RE: Degree of parallelism in SQL Server

    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...

  • RE: Degree of parallelism in SQL Server

    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...

Viewing 4 posts - 1 through 4 (of 4 total)