Documentation

Complete guides, tutorials, and reference documentation for every DBLense tool.

Query Analyzer

Analyze query execution patterns, detect anomalies, discover missing indexes, and get AI-powered tuning recommendations.

  • Getting Started Guide
  • 3-Tab Interface Reference
  • Anomaly Detector
  • Performance Tuning Tips
  • Workflow Examples

SQL Monitor

Real-time server monitoring with active requests, top CPU queries, wait statistics, and database size tracking.

  • Dashboard Overview
  • Active Requests
  • Wait Statistics
  • Connection Monitoring
  • Auto-Refresh Settings

Compare

Visual schema and data comparison between two SQL Server databases with synchronization script generation.

  • Schema Comparison
  • Data Comparison
  • Sync Script Generation
  • Visual Diff Viewer
  • Filtering Options

Parallel Backup

Multi-threaded database export and restore with snapshot consistency and progress tracking.

  • Export Configuration
  • Snapshot Consistency
  • Parallel Restore
  • Compression Settings
  • Azure MI Support

Script Runner

Execute SQL scripts across multiple servers and databases in one click with three execution modes.

  • Server Group Management
  • Execution Modes
  • GO Batch Splitting
  • Results & Export
  • Security & DPAPI

Trace Replay

Capture SQL Server Extended Events traces and replay them against a target server for performance testing.

  • Capture Configuration
  • Replay Settings
  • Performance Comparison
  • Dry-Run Mode
  • Azure MI Support

System Requirements (All Tools)

Client

  • Windows 10/11 or Windows Server 2016+
  • .NET 8.0 Runtime (or use self-contained package)
  • Zero installation — single portable .exe

Server

  • SQL Server 2016+ (on-premises)
  • Azure SQL Database
  • Azure SQL Managed Instance
  • Query Store enabled (for Query Analyzer)