1
kudos
spam Kudos Remove

SQL Server Performance series: Parallel query processing gotchas
published 432 days, 4 hours, 7 minutes ago posted by sasa 441 days, 4 hours, 38 minutes ago
Thursday, March 17, 2011 7:25:23 AM GMT Tuesday, March 08, 2011 6:54:23 AM GMT
SQL Server Performance series: Parallel query processing gotchas
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 & environment is different to each other on top of physical hardware configuration...(read more)
category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code
tags: DBA, maxdop, Memory, numa, Performance, Processes, resource governor, SQL Server, statiscs age, worker threads

No comments yet, be the first one to post comment.

To post your comment please login or signup