Game changer settings # MAXDOP and Cost threshold for parallelism

I got a performance tuning assignment for an esteemed customer in the Financial Services domain. I went through the wait stats of SQL Server using the built-in SQL Server Report, called Performance Dashboard. I found CPU – Parallelism referred to as CXPACKET was leading the list, followed by Buffer IO, Lock, and Latch. Parallelism in SQL Server refers to two settings – MAXDOP and Cost threshold … Continue reading Game changer settings # MAXDOP and Cost threshold for parallelism