tigertoolbox
tigertoolbox copied to clipboard
msdb indexes
Suggestion: Include an option to allow rebuild/reorg of system-generated table indexes, specifically those in msdb. The "WHERE mst.is_ms_shipped = 0" clause used throughout the code prevents this.
System tables should be included, an option is not required. Fragmentation can occur in msdb dbo.sysjobhistory for example.