Checks Explained

Here are the articles in this section:
Orphaned distributed transaction found
Auto Shrink Enabled
Auto Update or Auto Create Statistics Disabled
Configuration Running Values
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
Delayed Durability Level
Deprecated Column Types
Disabled Index
Duplicate or Overlapping Index
Enable TF1117 & TF1118
Excessive Free Space in Database File
Fill Factor Value is Same as Default
Fragmented Index
Hypothetical Index
I/O Bottleneck Detected
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
Old Backup History
Orphaned User
Page Verification Option
Parallelism Cost Threshold
Possible Data Corruption
Potential Unique Index
Profiler Running
Suggested Index
Superseded Index
TempDB Collation
TempDB Contention
TempDB Data File Count
TempDB on Shared Disk
TempDB Owner
TempDB Recovery Model
Unused Index
Failed Logins
Unused, Empty Table
High VLF Count
Backup Checksum Setting
Backup Compression Setting
Optimize For Ad Hoc Workloads
Remote Admin Connections
Index Create Memory (KB)
Default Fill Factor
Database Recovery Model
Identity Column Near Max
Autogrowth Occuring
Unused File Group
Disabled Check Constraint
Disabled Foreign Key
Query Store disabled, misconfigured, failed or close to failing
No Recent Transaction Log Backup
Default system administrator account is 'sa'
Data and Log Files on Same Volume