I got lots of emails about how to set MAXDOP for any query. Today we will be learning 3 different ways to set MAXDOP. Let us learn it today.
In the last 3 months, I have done nearly 11 consulting engagement for Dynamics NAV AX CRM while working on Comprehensive Database Performance Health Check.
If you are reading this blog regularly the name of Dominic Wirth may not be new for you. He has in the past sent some very interesting scripts for audit for our blog and I am including his new script in this blog which is about how to Get CPU and Memory Information with MAXDOP Guidelines.
My primary source of income for me is the Comprehensive Database Performance Health Check for any application using SQL Server. Recently, I was hired by a large organization which was struggling with the poor performance of their Microsoft Dynamics CRM. They had recently upgraded their SQL Server to the latest version of SQL Server and were facing slow queries, slow loading of the pages as well as white screens in the applications.