If you have a small database and a large maintenance window, using the index rebuild task is perfectly fine. 1.1.1 Below are sample results from that query:; 1.1.2 Once we confirm that we have Index fragmentation, we type the following command line to correct the issue:; 1.1.3 Note: This command may take some time . SCCM SQL fragmentation - reddit sccm 2012. The following predefined maintenance tasks should be scheduled to run on a weekly basis. Sccm Assessment these days, looking at various SCCM setup and configuration SQL backup is debatable. ConfigMgr 2012 Rebuilding Indexes criteria - Microsoft Tech Community It looks like the maintenance task 'Rebuild Indexes' was not actually doing anything. Easily apply. Site Maintenance Tasks in ConfigMgr 2012 RC2 : From your administration node—> Site Configuration—>Sites. Now that Current Branch 1906 (5..8853.1000) . As you might have already noticed that Configuration Manager PowerShell Provider is lot like Active Directory, Registry etc. -Review and adjust the SQL Server backup, if necessary. Sites, set up each discovery method SCCM built-in task or use the . The following script is what I use to run WSUS maintenance in my environemnts. How to Enable the ConfigMgr Rebuild Indexes Site Maintenance Task When you change the configuration of this maintenance task, the configuration applies to each applicable site in the hierarchy. You will see a list of all the build in ConfigMgr maintenance tasks. . How to Configure Ola Hallengren's Maintenance Scripts Hit a right-click on the index you need to reorganize and select reorganize from expended menu list. Grade II Building Engineer. 1906 - Roberts Blog - ConfigMgr Administrative Checklist for Configuration Manager Use either Sqlcmd or PowerShell (Invoke-Sqlcmd cmdlet ) to automate it. IndexOptimize is the SQL Server Maintenance Solution's stored procedure for rebuilding and reorganizing indexes and updating statistics. Does not actually locate new resources for SCCM products include SQL server solution.