Results Explained

Articles in this section:

Autogrowth Events Detected

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 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

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