Monthly Archives: April 2013

How to determine if the ConfigMgr Rebuild Indexes site maintenance task is running

Background (bug previously filed on connect) I’ve found that the indexes on our SQL Server instances for Configuration manager to be severely fragmented. In investigating, I discovered that even though the Rebuild Indexes site maintenance task was set to run … Continue reading

Posted in ConfigMgr, SQL Server | 2 Comments

MMS 2013 UD-B407 session files

As promised, attached are the demo files used for the session ‘UD-B407 – Advanced SQL Queries beyond the basics’ presentation. SQL Demo PowerShell Demo CMMonitor Demo (DB optimization) also here: https://stevethompsonmvp.files.wordpress.com/2013/04/ud-407-cmmonitor-demo.docx For those of you that were there, thank you … Continue reading

Posted in MMS 2013, SQL Server, UD-B407 | Leave a comment