RockSolid will either do Online (non-blocking) or Offline (blocking) database index maintenance depending on how you configure the database index maintenance window. For reference, the definitions of each of these modes is as follows:
- Offline – Traditional database index Rebuild (ALTER INDEX with the REBUILD option)
- Online – Either an online index rebuild, if configured and supported by SQL Server (see below), or a database index reorganize.
For more information on how to configure index maintenance see:Enabling RockSolid Automated Index Maintenance
For each index RockSolid will use a precedence hierarchy for determining the
appropriate rebuild method for each index, being:
- If an offline index rebuild window and offline rebuilds are allowed the REBUILD the index
- If an online index rebuild window, and online rebuilds are allowed and online rebuilds are supported then ONLINE REBUILD the index.
- If defrag is enable REOGRANISE the index
- Otherwise record fragmentation and update index statistics only (if configuration does not allow any rebuild to occur).
SQL Server Support for Index Maintenance Methods
Rebuild
- Supported by all versions and editions
Online Rebuilds
- Supported by SQL Server Enterprise Editions from version 2005 and above
- Supported on table indexes (clustered) and non-clusetered index without large object types (text, varchar(max), xml etc)
- Supported when page level locking is not disabled for a given index
Reorganise (defrag)
- Supported by all versions and editions
0 Comments