Perform rebuilds on all other databases on Saturday night at 10pm Perform index reorganization on all databases Sunday through Thursdays at 10pm. To achieve this using the default installed Minion Reindex jobs: Connect to and expand the SQL node. You’ll see two new jobs: “YourServer” MinionReindexDBs-All-All Runs once weekly Fridays at 3:00 AM - to thoroughly defragment – – indexes (rebuild). MinionReindexDBs-All-REORG Runs Daily 3:00 AM except for Friday to complete lightweight – – – defragmenting (reorganize). Edit the job: “MinionReindexDBs-All-All” Edit the step: add to the @Exclude parameter. “Reindex” ‘YourDatabase’ Edit the schedule to run Friday night at 11pm. Create a new job “MinionReindexDBs-YourDatabase-All”. Create a step similar to that in the job. Set @Include “Reindex” “MinionReindexDBs-All-All” to and set @Exclude to NULL. ‘YourDatabase’, Schedule it to run Saturday night at 10pm. Edit the schedules for the job to run Sunday through Thursday at “MinionReindexDBs-All-REORG” 10pm. How To: Configure how long the reindex logs are kept Minion Reindex stores the retention in days” setting (LogRetDays) in the Minion.IndexSettingsDB table “log and the Minion.IndexSettingsTable table. You can therefore set the log retention for individual tables, individual databases and/or the system as a whole. To change the default log retention for the system, run an update statement on the MinionDefault row in Minion.IndexSettingsDB. For example: UPDATE [Minion].[IndexSettingsDB] SET [LogRetDays] = 60 WHERE [DBName] = 'MinionDefault'; To change the log retention for a specific database, run an update statement on that database’s row in Minion.IndexSettingsDB. For example: UPDATE [Minion].[IndexSettingsDB] SET [LogRetDays] = 90 WHERE [DBName] = 'YourDatabase';
Perform rebuilds on all other databases on Saturday night at 10pm Perform index reorganization on all databases Sunday through Thursdays at 10pm. To achieve this using the default installed Minion Reindex jobs: Connect to “YourServer” and expand the SQL node. You’ll see two new jobs: MinionReindexDBs-All-All – Runs once weekly – Fridays at 3:00 AM - to thoroughly defragment indexes (rebuild). MinionReindexDBs-All-REORG – Runs Daily – 3:00 AM except for Friday – to complete lightweight defragmenting (reorganize). Edit the “MinionReindexDBs-All-All” job: Edit the “Reindex” step: add ‘YourDatabase’ to the @Exclude parameter. Edit the schedule to run Friday night at 11pm. Create a new job “MinionReindexDBs-YourDatabase-All”. Create a “Reindex” step similar to that in the “MinionReindexDBs-All-All” job. Set @Include to ‘YourDatabase’, and set @Exclude to NULL. Schedule it to run Saturday night at 10pm. Edit the schedules for the job “MinionReindexDBs-All-REORG” to run Sunday through Thursday at 10pm. How To: Configure how long the reindex logs are kept Minion Reindex stores the “log retention in days” setting (LogRetDays) in the Minion.IndexSettingsDB table and the Minion.IndexSettingsTable table. You can therefore set the log retention for individual tables, individual databases and/or the system as a whole. To change the default log retention for the system, run an update statement on the MinionDefault row in Minion.IndexSettingsDB. For example: UPDATE [Minion].[IndexSettingsDB] SET [LogRetDays] = 60 WHERE [DBName] = 'MinionDefault'; To change the log retention for a specific database, run an update statement on that database’s row in Minion.IndexSettingsDB. For example: UPDATE [Minion].[IndexSettingsDB] SET [LogRetDays] = 90 WHERE [DBName] = 'YourDatabase';
Reindexing.docx