Microsoft

System Center Configuration Manager Feedback

Suggestion box powered by UserVoice

How can we improve Configuration Manager?

Monitor database fragmentation and notify based on the value

One of the most issues found is database performance based on fragmented indexes. A notification or automatic defragmentation on for the relevant indexes would be nice.

15 votes
Vote
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
You have left! (?) (thinking…)
Marco Cibis (MS) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Michael Krueger commented  ·   ·  Flag as inappropriate

    It would make sense to configure SQL Server Index Optimization with Ola Hallengrens Maintenance Solution and simply enable this via the Rebuild Indexes function within ConfigMgr Site Maintenance settings.

  • Richard Balsley commented  ·   ·  Flag as inappropriate

    Don't forget to update statistics as well. Auto update of statistics in SQL works well in smaller tables, but as tables get larger the number of changed rows required to trigger an auto update becomes too large and the statistics become out of date.

Feedback and Knowledge Base