Problem

All databases should receive an index and statistics maintenance.

1.1 Index Maintenance

Regular Schedule: Daily at 06:00 PM local server time.

Solution: Native T-SQL using Ola Hallengren dbo.IndexOptimize and dbo.IndexOptimize_Polybase (recreates Polybase Statistics)

Wrapping procedure – DBA.maintenance.index_maintenance

1.2 Statistics Maintenance

Regular Schedule: Every 2 hours.

Solution: Native T-SQL using Ola Hallengren dbo.IndexOptimize and dbo.IndexOptimize_Polybase (recreates Polybase Statistics)

Wrapping procedure – DBA.bestpractices.usp_RefreshStatsonActiveDatabases

  1. Updates stats for TOP 25 (default) databases based on combined I/O reads+writes
  2. Recreate Polybase Statistics

2 Metrics

The statistics below reflect the history of daily indexing jobs for the last 60 days (as of 10.17.2023).