ConfigMgr: Troubleshooting High CPU utilization on the SQL server and Parallelism

  Hello Folks, This post is about troubleshooting CPU utilization of SQL Server hosting the ConfigMgr database. It talks about the general queries to find out the causes and talks specifically about parallelism.   To check which query is taking the Max CPU time run the following query     SELECT TOP 50 ObjectName =…

7