Introduction
Installation
Database Permissions
Health Checks
Requirements
Installation Issues
Profile Management
Estate
Adding Servers
Discovering Servers
Tag Management
Additional Features
Advisor
Performing an Analysis
Viewing the Results
Custom Index Naming Policies
Results Explained
Affinity Type
Agent Jobs Non Valid Owners
Auto Shrink Enabled
Auto Update or Auto Create Statistics Disabled
Autogrowth Occurring
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
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
I/O Bottleneck
Identity Column Nearing Or Reached Max
Index Create Memory
Index Fill Factor Set
Index Names
Invalid Database Owner
Index Used More than the Clustered
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
Ole Automation Procedures
Page Verification Option
Parallelism Cost Threshold
Possible Data Corruption
Potentially 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
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
Worker Threads
xp_cmdshell
Monitor
Custom Health Checks
Compare
Performing a Comparison
Checking Current Values
Snapshots
Custom Comparisons
Compare CLI
Script
Blog
Changelog
Monitor
Articles in this section:
Custom Health Checks