SCCM Secondary Site Maintenance Tasks – … Weekly Site Maintenance Tasks. No. This is required to support Kerberos authentication. It is very common to see big increase in performance after optimizing your SQL indexes. ConfigMgr (SCCM) 2012 site Maintenance Tasks – All about … I need to rebuild my SCCM -- database lost : SCCM Clear Install Flag. Use Status Message Query. To help with console latency, the rebuild index task can enabled with a Sunday 12:00AM to 5:00AM schedule. Tips for Improving SQL Performance 0 Sign in to vote Hi, You can enable the 'Rebuild Indexes' site maintenance task and make it weekly once or twice. It is very common to see big increase in performance after optimizing your … Use the Rebuild Index Task dialog to re-create the indexes on the tables in the database with a new fill factor. Example 1: Let say you are administrating a large … D) Perform SQL indexing. My previous post on the topic explained ways of rebuilding specific or all the indexes within a table. Powershell script to create SCCM maintenance window collections based on an external source (CMDB). Rebuild Index maintenance task failed due to deadlocks. Rebuild indexes task crashes sccm 2007 Don't forget to disable the ConfigMgr built-in … I implemented it for our environment a few years ago (DB + transaction log are around 350GB total) and wholeheartedly recommend it as well.