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.
Michael Krueger commented
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
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.