Performance Analysis

Query Analyzer

Deep-dive into SQL Server Query Store data to identify performance issues, execution regressions, missing indexes, and optimization opportunities with 25+ built-in performance tuning rules and AI-powered anomaly detection.

Download Free Trial View Documentation

Three-Tab Interface

Summary → Database → Query Deep Dive

Avg CPU Time

245ms

Executions/day

12,450

Missing Indexes

Tuning Rules

25+

Key Features

Everything you need to analyze and optimize SQL Server query performance.

Three-Tab Deep Dive Interface

Start with a server-wide Summary, drill into Database-level query analysis, and deep-dive into individual Query details with execution plans and statistics.

Day-Over-Day Comparisons

Automatically detect performance regressions by comparing execution counts, durations, CPU times, and logical reads between today and yesterday.

Missing Index Detection

Identifies SQL Server's missing index recommendations with ready-to-copy CREATE INDEX statements, impact scores, and estimated improvement percentages.

Unused Index Tracking

Find indexes that consume write overhead but are never used by queries. Reclaim storage and improve write performance by removing dead indexes.

25+ Performance Tuning Rules

Built-in rules analyze query patterns and automatically surface recommendations for improving performance, reducing resource consumption, and fixing anti-patterns.

AI Anomaly Detection (Enterprise)

Automatically detect anomalies across 9 symptom categories: High CPU, Blocking, Memory Pressure, I/O Bottlenecks, TempDB contention, and more.

Statistics Freshness Monitoring

Track when table statistics were last updated and identify stale statistics that may be causing suboptimal query plans.

Execution Plan Visualization

View graphical execution plans directly in the tool. Identify costly operators, missing indexes in plans, and plan regressions (Enterprise edition).

Available Editions

Choose the edition that fits your needs.

Trial

Free Trial

$0 / 14 days

Full feature access for evaluation

✓ All Standard features
✓ Query Store analysis
✓ Missing index detection
✓ Performance tuning rules
✗ AI Anomaly Detection
✗ Execution plans

Download Trial

Standard

$199 / year

For individual DBAs and small teams

✓ Query Store analysis
✓ Day-over-day comparisons
✓ Missing & unused indexes
✓ 25+ tuning rules
✓ Statistics monitoring
✗ AI Anomaly Detection

Buy Standard

Enterprise

$499 / year

Full power for enterprise environments

✓ All Standard features
✓ AI Anomaly Detection
✓ 9 symptom categories
✓ Execution plan viewer
✓ Root cause analysis
✓ Priority support

Buy Enterprise