Category Archives: ConfigMgr

How to apply a SQL Server update for ConfigMgr

This example is used to illustrate applying the latest SQL Cumulative Update to SQL 2016, this CM Site server happens to be running current branch 1710. This same process would be used to update SQL Server with a service pack … Continue reading

Posted in ConfigMgr, SQL Server, SQL Server 2016 | Leave a comment

Properly configure SQL Server ConfigMgr database

Ideally, this will take place before you install ConfigMgr! First, estimate size(s) of the databases: SCCM SUSDB TempDB – see prior article for more detail How? Use the  SCCM DB Sizing estimator! Shown is an example of the Database sizing … Continue reading

Posted in ConfigMgr, SQL, SQL Server | 12 Comments

Supported SQL Server versions for SCCM CB upgrades

Had a question recently on what version of SQL Server is supported for upgrade to SCCM CB (current branch). Scenario was this; client was running SQL 2012 SP2 for their SCCM 2012 R2. However, in order to upgrade to SCCM  … Continue reading

Posted in ConfigMgr, SQL Server | 4 Comments

SCCM File Backup Considerations

Everyone (hopefully) is aware that the SCCM database needs to be backed up. And, that there a number of other components that need to be backed up in order to have everything on hand in case there is a need … Continue reading

Posted in ConfigMgr, SCCM, SQL Server | 1 Comment

Optimizing SCCM Databases Revisited

Since Optimizing ConfigMgr databases was published in May 2013, I have received some tremendous feedback, all positive. The basics of that original post have not changed, Ola Hallengrens Index Optimization scripts, hands down, is the best solution for 99% of … Continue reading

Posted in ConfigMgr, SQL Server | 16 Comments

Why you should not use the ConfigMgr rebuild index task

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

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 | 1 Comment