Introduction
Installation
Database Permissions
Health Checks
Requirements
Installation Issues
Profile Management
Estate
Adding Servers
Discovering Servers
Tag Management
Additional Features
Optimize
Performing an Analysis
Viewing the Results
Custom Index Naming Policies
Results Explained
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 Compatibility Level
Database File Auto Growth
Database File Auto Growth Disabled
Database File Count
Database File Free Space
Database File Initialization Disabled
Database Files of Differing Sizes
Database Recovery Model
DBCC CHECKDB
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 and TF1118
Excessive Free Space in Database File
Failed Logins
Fill Factor Value is Same as Default
Fragmented Index
High VLF Count
Hypothetical Index
Identity Column Nearing Or Reached Max
Index Create Memory
Index Fill Factor Set
Index Names
Index Used More than the Clustered
Invalid Database Owner
I/O Bottleneck Detected
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 Distributed Transaction Found
Orphaned User
Page Verification Option
Parallelism Cost Threshold
Possible Data Corruption
Potentially Unique Index
Profiler Running
Query Store Disabled, Failed or Close to Failing
Remote Admin Connections
Suggested Index
Superseded Index
SQL Server Support Expired
TempDB Collation
TempDB Contention
TempDB Data File Count
TempDB on Shared Disk
TempDB Owner
TempDB Recovery Model
Unused Empty Table
Unused File Group
Unused Index
Check
Custom Health Checks
Compare
Performing a Comparison
Checking Current Values
Snapshots
Custom Comparisons
Compare CLI
Script
Blog
Changelog
Requirements
Required Packages
.NET Framework 4.5
Microsoft Visual C++ 2010 Redistributable Package (x64)