SentryOne Database Maintenance

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.

SentryOne Index Defragmentation ReportIndex 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.