Purpose
This table holds the thresholds used to determine when to change the tuning of a backup.
For more information, see the sections “About: Dynamic Backup Tuning Thresholds” and “How to: Set up dynamic backup tuning thresholds”.
| Column Name | Data Type | Definition |
| ID | int | Primary key row identifier. |
| DBName | sysname | Database name. |
| BackupType | Varchar | Backup type. Valid inputs: ALL, Full, Diff, Log. Note that ALL encompasses full, differential, and log backups. |
| SpaceType | varchar | The way in Minion Backup determines the size of the database (e.g., data only, data and index, etc.) Note that this column is ignored for log backups, but you should put “Log” here anyway for rows where BackupType=Log, because it’s descriptive. Valid inputs: DataAndIndex, Data, File, Log |
| ThresholdMeasure | char | The measure for our threshold value. Valid inputs: GB |
| ThresholdValue | bigint | The correlating value to ThresholdMeasure. So. if ThresholdMeasure is GB, then ThresholdValue is the value – the number of gigabytes. |
| NumberOfFiles | tinyint | The number of files to use for the backup. |
| Buffercount | Smallint | From MSDN.Microsoft.com: “Specifies the total number of I/O buffers to be used for the backup operation. You can specify any positive integer; however, large numbers of buffers might cause "out of memory" errors because of inadequate virtual address space in the Sqlservr.exe process.” |
| MaxTransferSize | bigint | Max transfer size, as specified in bytes. This must be a multiple of 64KB. Note that a value of 0 will allow Minion Backup to use the SQL Server default value, typically 1MB. From MSDN.Microsoft.com: “Specifies the largest unit of transfer in bytes to be used between SQL Server and the backup media. The possible values are multiples of 65536 bytes (64 KB) ranging up to 4194304 bytes (4 MB).” |
| Compression | bit | From MSDN.Microsoft.com: “In SQL Server 2008 Enterprise and later versions only, specifies whether backup compression is performed on this backup, overriding the server-level default.” |
| BlockSize | bigint | From MSDN.Microsoft.com: “Specifies the physical block size, in bytes. The supported sizes are 512, 1024, 2048, 4096, 8192, 16384, 32768, and 65536 (64 KB) bytes. The default is 65536 for tape devices and 512 otherwise. Typically, this option is unnecessary because BACKUP automatically selects a block size that is appropriate to the device. Explicitly stating a block size overrides the automatic selection of block size.” |
| BeginTime | varchar | The start time at which this threshold applies. IMPORTANT: Must be in the format hh:mm:ss, or hh:mm:ss:mmm (where mmm is milliseconds), on a 24 hour clock. This means that both ’00:00:00’ and ’08:15:00:000’ are valid times, but ‘8:15:00:000’ is not (because single digit hours must have a leading 0). |
| EndTime | varchar | The end time at which this threshold applies. IMPORTANT: Must be in the format hh:mm:ss, or hh:mm:ss:mmm (where mmm is milliseconds), on a 24 hour clock. This means that both ’00:00:00’ and ’08:15:00:000’ are valid times, but ‘8:15:00:000’ is not (because single digit hours must have a leading 0). |
| DayOfWeek | Varchar | The day or days to which the settings apply. Valid inputs: Weekday, Weekend, [an individual day, e.g., Sunday] |
| IsActive | Bit | Whether the current row is valid (active), and should be used in the Minion Backup process. |
| Comment | Varchar | For your reference only. You can label each row with a short description and/or purpose. |