Discover Integrity Issues
Identifies SQL Server database integrity issues and highlights recovery methods which may leave the database in a potentially unrecoverable state.
Diagnose indexes to determine possible performance optimizations.
Examine Windows and SQL Server configuration settings.
Identify configuration settings that cause processor bottlenecks.
Uncover many of the most common holes in security settings.
Analyzes the most popular wait statistics which cause SQL server query delays (cxpacket, pageiolatch, async_network_io).
Blocking and Deadlocking
Determine which sessions are blocking or are involved in a deadlock.
Long Running Jobs
Identify jobs and transactions that may be running longer than usual
Diagnose issues with networking hardware or bandwidth
Easily view all sessions that are currently active with detailed performance metrics collected from Dynamic Management Views (DMV).
Query Plan Statistics
Displays statistical details about query plan and delivers recommendations for improving their performance.
SQL Query Tuning
Identify up to 40 of the most common query syntax inefficiencies then tune to improve efficiency.
Evaluate the most troublesome queries and gain immediate suggestions to improve their performance.
Export performance recommendations for easy distribution.
Schedule Tune Ups
Schedule daily or weekly check-ups to keep your SQL Servers performing in top shape.