SQL Server Performance

SQL Server Performance series: Parallel query processing gotchas

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Mar 6, 2011.

  1. Anonymous New Member

    Parallel query processing is one of the best performance features available from SQL Server 2008 version onwards. By default Microsoft documentation suggests to change MAXDOP settings remain equal to number of physical processors that are being used on the server. Further that suggestion is documented in KBA322385 article too, but it may not be an optimal solution for all the server environments as every installation &amp; environment is different to each other on top of physical hardware configuration...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2011/03/07/10004.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=10004" width="1" height="1">

Share This Page