QueryStore Analyzer
Analyze query execution patterns, detect anomalies, discover missing indexes, and get AI-powered tuning recommendations.
- Overview
- Getting Started
- Interface & Features
- Common Workflows
- Tips & FAQ
Script Runner
Execute SQL scripts across multiple servers and databases in one click with templates, validation, and flexible execution modes.
- Overview
- Getting Started
- Interface & Features
- Common Workflows
- Tips & FAQ
Log Reader
Analyze SQL Server transaction logs, generate undo/redo recovery scripts, and audit every data change with a visual timeline.
- Overview
- Getting Started
- Interface & Features
- Common Workflows
- Tips & FAQ
Compare
Compare schema and data between two SQL Server databases, review side-by-side definitions, and generate sync scripts.
- Overview
- Getting Started
- Interface & Features
- Common Workflows
- Tips & FAQ
SQL Server XRAY
Assess SQL Server health, configuration, and best practices with 200+ checks and actionable remediation guidance.
- Overview
- Getting Started
- Interface & Features
- Common Workflows
- Tips & FAQ
Trace Replay
Capture Extended Events, compare traces, and replay workloads with multi-threaded simulation and performance reports.
- Overview
- Getting Started
- Interface & Features
- Common Workflows
- Tips & FAQ
Query Benchmark
Run controlled SQL benchmarks across servers or query versions with plan comparison and shareable reports.
- Overview
- Getting Started
- Interface & Features
- Common Workflows
- Tips & FAQ
Security Manager
Manage SQL Server logins, users, roles, permissions, access templates, compliance, and security drift from one control plane.
- Overview
- Getting Started
- Interface & Features
- Common Workflows
- Tips & FAQ
Activity Monitor
Full user guide: live DMVs, Agent collectors, Performance sources, tabs, alerts, and how to control intervals and retention.
- Overview
- Getting Started
- Interface & Features
- Common Workflows
- Tips & FAQ
SQL Monitor
Portable instance triage plus Enterprise multi-instance monitoring with collectors, alert rules, and notification channels.
- Overview
- Getting Started
- Interface & Features
- Common Workflows
- Tips & FAQ
SQL Server Auditor
Install, configure, and operate SQL audit collection: events, alerts, compliance reports, SIEM hooks, and service management.
- Overview
- Getting Started
- Interface & Features
- Common Workflows
- Tips & FAQ
Data Studio
Parallel backup/restore, streaming migrate, and cross-platform export/import with progress tracking and column mapping.
- Overview
- Getting Started
- Interface & Features
- Common Workflows
- Tips & FAQ
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 QueryStore Analyzer)