Checks Explained

Here are the articles in this section:

Autogrowth Occurring
Auto Shrink Enabled
Auto Update or Auto Create Statistics Disabled
Backup Checksum Setting
Backup Compression Setting
Configuration Running Values
Data and Log Files on Same Volume
Database Auto Close
Database Compatability Level
Database File Auto Growth Disabled
Database File Auto Growth
Database File Count
Database File Initialization Disabled
Database File Free Space
Database Files of Differing Sizes
Database Recovery Model
DBCC CHECKDB
Default Fill Factor
Delayed Durability Level
Deprecated Column Types
Disabled Check Constraint
Disabled Foreign Key
Disabled Index
Default system administrator account is 'sa'
Duplicate or Overlapping Index
Enable TF1117 & TF1118
Excessive Free Space in Database File
Failed Logins
Fill Factor Value is Same as Default
Fragmented Index
High VLF Count
Hypothetical Index
I/O Bottleneck Detected
Identity Column Near Max
Index Create Memory (KB)
Index Fill Factor Set
Index Names
Invalid Database Owner
Little Used Index
Log File Count
Low Memory
Max Degree of Parallelism
Maximum Memory Too High
Maximum Memory Too Low
Memory Model
New Update Available
No Clustered Index
No Recent Transaction Log Backup
Old Backup History
Optimize For Ad Hoc Workloads
Orphaned User
Page Verification Option
Parallelism Cost Threshold
Possible Data Corruption
Potential Unique Index
Profiler Running
Remote Admin Connections
Suggested Index
Superseded Index
TempDB Collation
TempDB Contention
TempDB Data File Count
TempDB on Shared Disk
TempDB Owner
TempDB Recovery Model
Unused Index
Unused, Empty Table
Unused File Group
Query Store disabled, misconfigured, failed or close to failing