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
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Marco Cibis (MS) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      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