Results Explained

Articles in this section:

Affinity Type

Agent Jobs Non Valid Owners

Auto Shrink Enabled

Auto Update or Auto Create Statistics Disabled

Autogrowth Events

Backup Checksum Setting

Backup Compression Setting

Backup Messages

Blocked Process Threshold

Boost SQL Priority

CLR Integration

Configuration Running Values

Cores per Socket

Data and Log Files on Same Volume

Data Purity

Database Auto Close

Database Compatibility Level

Database File Auto Growth Disabled

Database File Auto Growth

Database File Count

Database File Free Space

Database File Initialization Disabled

Database Files of Differing Sizes

Database Recovery Model


Default Fill Factor

Default System Administrator Account Is 'sa'

Delayed Durability Level

Deprecated Column Types

Disabled Check Constraint

Disabled Foreign Key

Disabled Index

Duplicate or Overlapping Index

Enable TF1117 & TF1118

Excessive Free Space in Database File

Failed Logins

Fill Factor Value Equals as Default

Fragmented Index

High VLF Count

Hypothetical Index

I/O Bottleneck

Identity Column Nearing Or Reached 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

No Clustered Index

No Recent Transaction Log Backup

Old Backup History

Ole Automation Procedures

Optimize For Ad Hoc Workloads

Orphaned User

Page Verification Option

Parallelism Cost Threshold

Possible Data Corruption

Potential Unique Index

Profiler Running

Query Store Disabled, Failed or Close to Failing

Query Store Trace Flags

Remote Access

Remote Admin Connections

Scan For Startup Procs

Suggested Index

Superseded Index

TempDB Collation

TempDB Contention

TempDB Data File Count

TempDB on Shared Disk

TempDB Owner

TempDB Recovery Model

Unused File Group

Unused Index

Unused, Empty Table

Update SQL Server

Worker Threads