Your browser (Internet Explorer 6) is out of date. It has known security flaws and may not display all features of this and other websites. Learn how to update your browser.

ConfigMgr 2012: SQL Maintenance Plans and Index Optimization Recommendations

Recently caught some emails going around about recommended backup and maintenance plans as it relates to ConfigMgr. Also plenty of discussions around whether or not addition index optimization is required beyond the built-in Rebuild Indexes task that can be configured as part of the built-in Site Maintenance task. 

As far as what I recommend and configure for the clients I work with. I use the recommendations from Steve Thompson a fellow MVP and former SQL MVP.

SQL Server Backup Recommendations

How to determine if indexing task is running

Optimizing the ConfigMgr databases

I would highly recommend you read through the above linked posts. The maintenance plan is what I use for backing up the CM database and supporting databases. I do not use the built-in backup task with ConfigMgr 2012.  

If you are having issues with indexing or slow performance, then it’s a good idea to look into the index optimization recommendations as well. 

  • Chris,
    Would you mind doing a demo on how you would set it up?
    A sort of step by step? I’m not an SQL guy so it’s a little like chines to me…lol


    July 23, 2014

  • Sure, be happy to provide a step by step, give me a couple days to get it together.


    July 23, 2014

  • Thank you!


    July 25, 2014

Leave a comment  




Submit comment