Does anyone have any suggestions? This reduces fragmentation significantly. My previous post on the topic explained ways of rebuilding specific or all the indexes within a table. And the solution will automatically choose depending on fragmentation level and if you have SQL Server Enterprise the "Rebuild Online" option will be available. You can use the built-in Rebuild Index site maintenance task or use the Ola Hallengren's SQL Server maintenance solution. Rebuild Indexes. Talking Database in ConfigMgr | Argon Systems Right-click on the fragmented index and select Rebuild or Reorganize option in the context menu (depending on the desired action): Click the OK button and wait for the process to complete. sccm site maintenance tasks best practice - maxi-tech.be Now that we have completed our SQL Maintenance Plan, let's go ahead and configure the Rebuild Index site maintenance task in ConfigMgr to avoid any overlap between ConfigMgr and SQL. SCCM Performance Tuning - How to Fix Slow SCCM - Part 2 SCCM Administration Best Practices: 1. Talking Database in ConfigMgr - Microsoft Tech Community Feb 14 2019 12:58 PM. Rebuild Index Task (Maintenance Plan) - SQL Server | Microsoft Docs Rebuild Indexes: Use this task to rebuild the Configuration Manager database indexes. FragmentationLevel2 = 80%. SC Configuration Manager 2012 - James Avery ConfigMgr 2012 Index Optimization - James Avery's Blog Inconsistent Rebuild Index task in maintenance plan OK, so now we see that we have defragmentation on our indexes, so SQL wise to maintain the Indexes there are three methods of doing that. How to Enable the ConfigMgr Rebuild Indexes Site Maintenance Task Maintaining WSUS Like a Boss! - Deployment Research -Review and adjust the SQL Server backup, if necessary. A maintenance task is a task in Configuration Manager that performs maintenance on sites and databases. I chose and ran the Rebuild Indexes maintenance task (changed its scheduled +5 mins into the future) to see if the values are shown once a task runs post-upgrade. writer will install on each physical computer node of the Microsoft Windows Server cluster to support the Backup Site Server maintenance task. Scan the SMSDBMON.LOG or SMSDBMON.LO_ files using your favorite log file reader; search on the key word Indexes. In list find Rebuild Indexes and click Edit; 4.