It's important that regular maintenance activities be performed on the SentryOne database to ensure optimal performance. The following are suggested practices for performing such maintenance.
Weekly
Index Rebuilds
Weekly Index rebuilds are recommended. Fragmentation Manager can be used to help you make intelligent decisions about index management in your environment. For more information, see the Fragmentation Manager topic.
Index Defragmentation Details Report
Nightly
Database Integrity Checks
Database integrity checks should be performed as often as practical for the SentryOne database. They can be scheduled through SQL Server Agent Jobs with T-SQL or free solutions such as Ola Hallengren's Integrity Check or Maintenance Plans.
Index Defragmentation
Fragmentation Manager can be used to help you make intelligent decisions about index management in your environment.
Configuring the SentryOne Database Maintenance Window
The Maintenance Window should also be configured with the above activity scheduled to avoid excessive Failsafe Notifications.
