Performance Analysis

QueryStore 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.

DBLense QueryStore Analyzer interface

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

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).

Simple, Per-User Pricing

Volume discounts for teams. Pay per seat, billed annually.

Trial

Free Trial

$0 / 14 days

Full feature access for evaluation

  • All features included
  • Query Store analysis
  • Missing index detection
  • AI Anomaly Detection
  • Execution plan viewer
Download Trial
Bundle

Suite

$200 /user/year

QueryStore Analyzer + Script Runner

  • 1–5 users: $200/user/year
  • 6–12 users: $170/user/year
  • 13+ users: $150/user/year
  • Both tools included
  • Best value for teams
See Pricing & Buy

System Requirements

OS:Windows 10/11 or Windows Server 2016+
Runtime:Self-contained (.NET 8 bundled)
SQL Server:SQL Server 2016+ with Query Store enabled
Azure:Azure SQL DB & Managed Instance
Auth:Windows, SQL, Azure Entra ID (MFA)
Install:Zero install — single .exe file

Start Analyzing Your SQL Server Queries

Download the free 14-day trial and uncover hidden performance issues in minutes.