Category Archives: ConfigMgr

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 | 7 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 | 2 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

Installing and configuring SQL Server for Configuration Manager

This guide is intended to assist administration in properly configuring SQL Server prior to installing Configuration Manager. Too many make the mistake of miss-configuring SQL Server, then need to spend a LOT of time later, correcting it. Article Contents Installing … Continue reading

Posted in ConfigMgr, SQL Server, SQL Server 2012, SQL Server 2014 | 4 Comments

Configuration Manager SQL Server Backup guidelines

  As previously documented, using native SQL Server backup for ConfigMgr recovery has been supported since CM 2012 Sp1 and later. SQL backups are the preferred technique for backing up the ConfigMgr for a number of reasons. Here is my … Continue reading

Posted in ConfigMgr, SQL Server, SQL Server 2012, SQL Server 2014 | 11 Comments

Downloading updates fails zero percent complete

Examined a server recently that refused to download deployed security updates. This server was also a Distribution Point in a remote location. Further, this site is running CM Current Branch. Software Center presented the following: DataTransfer.log showed something similar to … Continue reading

Posted in ConfigMgr | 2 Comments