| Affinity Type |
Instance |
| Agent Jobs Non Valid Owners |
Instance |
| Auto Shrink Enabled |
Database |
| Auto Update or Auto Create Statistics Disabled |
Database |
| Autogrowth Events |
Database |
| Backup Checksum Setting |
Instance |
| Backup Compression Setting |
Instance |
| Backup Messages |
Instance |
| Blocked Process Threshold |
Instance |
| Boost SQL Priority |
Instance |
| CLR Integration |
Instance |
| Configuration Running Values |
Instance |
| Cores per Socket |
Instance |
| Data and Log Files on Same Volume |
Database |
| Data Purity |
Database |
| Database Auto Close |
Database |
| Database Compatibility Level |
Database |
| Database File Auto Growth Disabled |
Database |
| Database File Auto Growth |
Database |
| Database File Count |
Database |
| Database File Free Space |
Database |
| Database File Initialization Disabled |
Instance |
| Database Files of Differing Sizes |
Database |
| Database Recovery Model |
Database |
| DBCC CHECKDB |
Database |
| Default Fill Factor |
Table |
| Default System Administrator Account Is 'sa' |
Instance |
| Delayed Durability Level |
Database |
| Deprecated Column Types |
Table |
| Disabled Check Constraint |
Table |
| Disabled Foreign Key |
Table |
| Disabled Index |
Table |
| Duplicate or Overlapping Index |
Table |
| Enable TF1117 & TF1118 |
Instance |
| Excessive Free Space in Database File |
Database |
| Failed Logins |
Instance |
| Fill Factor Value Equals as Default |
Table |
| Fragmented Index |
Table |
| High VLF Count |
Database |
| Hypothetical Index |
Table |
| I/O Bottleneck |
Instance |
| Identity Column Nearing Or Reached Max |
Table |
| Index Create Memory (KB) |
Instance |
| Index Fill Factor Set |
Instance |
| Index Fill Factor Set |
Table |
| Index Names |
Table |
| Invalid Database Owner |
Database |
| Little Used Index |
Table |
| Log File Count |
Database |
| Low Memory |
Instance |
| Max Degree of Parallelism |
Instance |
| Maximum Memory Too High |
Instance |
| Maximum Memory Too Low |
Instance |
| Memory Model |
Instance |
| No Clustered Index |
Table |
| No Recent Transaction Log Backup |
Database |
| Old Backup History |
Instance |
| Ole Automation Procedures |
Instance |
| Optimize For Ad Hoc Workloads |
Instance |
| Orphaned Distributed Transaction Found |
Instance |
| Orphaned User |
Database |
| Page Verification Option |
Database |
| Parallelism Cost Threshold |
Instance |
| Possible Data Corruption |
Database |
| Potential Unique Index |
Table |
| Profiler Running |
Instance |
| Query Store Disabled, Failed or Close to Failing |
Database |
| Query Store Trace Flags |
Instance |
| Remote Access |
Instance |
| Remote Admin Connections |
Instance |
| Scan For Startup Procs |
Instance |
| SQL Server Supported |
Instance |
| Suggested Index |
Table |
| Superseded Index |
Table |
| TempDB Collation |
Instance |
| TempDB Contention |
Instance |
| TempDB Data File Count |
Instance |
| TempDB on Shared Disk |
Instance |
| TempDB Owner |
Instance |
| Unused File Group |
Database |
| Unused Index |
Table |
| Unused, Empty Table |
Table |
| Update SQL Server |
Instance |
| Worker Threads |
Instance |
| xp_cmdshell |
Instance |