Specify index maintenance operations to be performed on a low-fragmented index. USER_DATABASES, -AVAILABILITY_GROUP_DATABASESĪll user databases that are not in availability groupsĪll databases that have “Db” in the name, except Db1Īll databases that do not have “Db” in the name ValueĪll system databases (master, msdb, and model)

All of these operations can be combined by using the comma (,). The hyphen character (-) is used to exclude databases, and the percent character (%) is used for wildcard selection. The keywords SYSTEM_DATABASES, USER_DATABASES, ALL_DATABASES, and AVAILABILITY_GROUP_DATABASES are supported. The SQL Server Maintenance Solution is free. The SQL Server Maintenance Solution is available on GitHub. You can also download the objects as separate scripts. This script creates all the objects and jobs that you need. Downloadĭownload MaintenanceSolution.sql. IndexOptimize is supported on SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance. IndexOptimize is the SQL Server Maintenance Solution’s stored procedure for rebuilding and reorganizing indexes and updating statistics. SQL Server Index and Statistics Maintenance

Sql server rebuild system databases