Monthly Archives: November 2016

Optimizing SCCM Databases Revisited

Posted on November 29, 2016 by ConfigMgrMVP

Since Optimizing ConfigMgr databases was published in May 2013, I have received some tremendous feedback, all positive. Note [9-3-2021]: This post has good background on the manual process, to automate in about 5 lines of PowerShell code read this… The … Continue reading →

Posted in ConfigMgr, SQL Server | 37 Comments

Why you should not use the ConfigMgr rebuild index task

Posted on November 16, 2016 by ConfigMgrMVP

Rebuilding the database indexes is a good thing, yes? Absolutely. Why not use the ConfigMgr rebuild index maintenance task? When the maintenance task works, and I have proof that some of the time it fails to run on ConfigMgr: It … Continue reading →

Posted in ConfigMgr, SQL Server | 3 Comments

SQL Server MAXDOP and effect on ConfigMgr

Posted on November 4, 2016 by ConfigMgrMVP

What is MAXDOP? SQL Server MAX Degree Of Parallelism (MAXDOP) configuration option controls the number of processors that are used for the execution of a query in a parallel plan. This option determines the computing and thread resources that are … Continue reading →

Posted in ConfigMgr, SQL, SQL Server 2016 | 2 Comments