Minion CheckDB allows you to automate whether databases get a DBCC CheckDB operation, or a DBCC CheckTable operation. Configure dynamic thresholds in the Minion.CheckDBSettingsAutoThresholds table. These settings only apply to runs of the stored procedure Minion.CheckDBMaster where OpName = ‘Auto’ in Minion.CheckDBSettingsDB (or, for a manual run, where @OpName = ‘Auto’).

The default entry that comes installed with Minion CheckDB sets a threshold by size, at 100 GB. What this means is that by default – for Minion.CheckDBMaster runs with @OpName = ‘Auto’, any database under 100 GB gets a CheckDB operation instead of a CheckTable operation.

Note: As outlined in the “Configuration Settings Hierarchy” section, more specific settings in a table take precedence over less specific settings. So if you insert a database-specific row for DB1 to this table, that row will be used for DB1 (instead of the “MinionDefault” row).

For more information, see “How to: Configure Dynamic Thresholds”.