Documentation
How To: Generate reindex statements only Sometimes it is useful to generate index maintenance statements and run them by hand, individually or in smal...
Mon, Jul 30, 2018 at 5:50 PM
How To: Reindex only indexes that are marked ONLINE = ON (or, only ONLINE = OFF) You can choose the set of indexes to maintain at a time. One of the...
Mon, Jul 30, 2018 at 5:55 PM
How To: Gather index fragmentation statistics on a different schedule from the reindex routine Maintenance windows are never the wide open space w...
Mon, Jul 30, 2018 at 6:00 PM
How To: Exclude databases from index maintenance You can exclude a database from all index maintenance in any of three ways: Database level settings...
Mon, Jul 30, 2018 at 6:04 PM
How To: Exclude a table from index maintenance To exclude a single table from all index maintenance, insert a row to the Minion.IndexSettingsTable tab...
Mon, Jul 30, 2018 at 6:06 PM
How To: Run code before or after index maintenance You can schedule code to run before or after index maintenance operations. There are several option...
Mon, Jul 30, 2018 at 6:13 PM
How To: Reindex databases on different schedules Create a new job for each different schedule you require for index maintenance. Let us take a simple ex...
Mon, Jul 30, 2018 at 6:15 PM
How To: Configure how long the reindex logs are kept Minion Reindex stores the "log retention in days" setting (LogRetDays) in the Minion.I...
Mon, Jul 30, 2018 at 6:18 PM
Overview of Tables Settings (like rebuild threshold) are stored in two separate tables, one for database-level defaults, and another for table-level...
Mon, Jul 30, 2018 at 6:25 PM
Minion.IndexSettingsDB This table holds index maintenance default settings at the default and database levels. You may insert rows for individual da...
Mon, Jul 30, 2018 at 6:34 PM