Wait Stats - Analyzes the most popular wait statistics which cause SQL server query delays (cxpacket, pageiolatch, asyncnetwork)

Disaster Recovery- Identifies SQL Server database integrity issues and recovery methods that may leave the database in a potentially unrecoverable state
Query Plan Statistics - Displays statistical details about query plan and additionally delivers recommendations for improving their performance.

SQL Query Tuning - Identify up to 40 of the most common query syntax inefficiencies

Index Optimization - Diagnose indexes to determine possible performance optimizations

Server Configuration - Examine Windows and SQL Server configuration settings

Security Settings - Uncover many of the most common holes in security settings

Blocking and Deadlocking - Determine which sessions are blocking or are involved in a deadlock

Long Running Jobs, Transactions - Identify jobs and transactions that may be running longer than usual

Processor - Identify configuration settings as well as many other issues that can cause processor bottlenecks

Memory - Pinpoint memory usage and configuration performance problems

Disk - Uncover a multitude of disk and database configuration and performance issues

Network - Diagnose issues with networking hardware or bandwidth