How To: Configure settings for a single database



Default settings for the whole system are stored in the Minion.IndexSettingsDB table. To specify settings for a specific database that override those defaults (for that database), insert a row for that database to the Minion.IndexSettingsDB table. For example: 



INSERT INTO [Minion].[IndexSettingsDB]
( DBName ,
  [Exclude] ,
  [ReindexGroupOrder] ,
  [ReindexOrder] ,
  [ReorgThreshold] ,
  [RebuildThreshold] ,
  [FILLFACTORopt] ,
  [PadIndex] ,
  [SortInTempDB] ,
  [DataCompression] ,
  [GetRowCT] ,
  [GetPostFragLevel] ,
  [UpdateStatsOnDefrag] ,
  [LogIndexPhysicalStats] ,
  [IndexScanMode] ,
  [LogProgress] ,
  [LogRetDays] ,
  [LogLoc] ,
  [MinionTriggerPath] ,
  [IncludeUsageDetails] 
)
VALUES( 'YourDatabase' ,--DBName ,
  0 ,--Exclude ,
  0 ,--ReindexGroupOrder ,
  0 ,--ReindexOrder ,
  10 ,--ReorgThreshold ,
  20 ,--RebuildThreshold ,
  80 ,--FILLFACTORopt ,
  'ON' ,--PadIndex ,
  'OFF' ,--SortInTempDB ,
  NULL ,--DataCompression ,
  1 ,--GetRowCT ,
  1 ,--GetPostFragLevel ,
  1 ,--UpdateStatsOnDefrag ,
  0 ,--LogIndexPhysicalStats ,
  'Limited' ,--IndexScanMode ,
  1 ,--LogProgress ,
  60 ,--LogRetDays ,
  'Local' ,--LogLoc ,
  '\\minioncon\c$' ,--MinionTriggerPath ,
  1--IncludeUsageDetails 
);