SQL Performance Intelligence
SQL PerformanceIntelligence™
Getting Started
OverviewInstallationQuickstart
Modules
DashboardQuery StatisticsIndex AdvisorBlocking AnalysisWait StatisticsSecurity AuditScheduled JobsObject Explorer

Documentation

Practical setup and module usage guide for SQL Performance Intelligence.

Before You Begin

  1. Add at least one SQL Server connection in Settings > Database.
  2. Activate the connection with Connect.
  3. From the Info Bar, select active Server, Database, and (if needed) AI Model.

Overview

What it does
  • Analyzes SQL Server objects, plans, and query signals.
  • Generates evidence-backed, audit-ready reports.
  • Runs offline by default with Local LLM support.
What it doesn't do
  • No automatic schema changes or auto-apply actions.
  • No background agents or persistent collectors.
  • No table/row data extraction as a collection step.
Read the Overview

Installation

Use the standard Windows installer for desktop environments. Offline installer is available for controlled networks.

# Example silent install
msiexec /i "SQL Performance Intelligence.msi" /quiet /norestart
Note
Signed binaries are provided for enterprise change-control workflows.
View installation details

Database User Permissions

The application operates in read-only mode. Minimum required permissions may vary by environment; these are recommended for initial setup.

Note
Grant only required permissions and remove unnecessary privileges.
  • CONNECT (connection to target database)
  • VIEW SERVER STATE (instance-level performance metrics)
  • VIEW DATABASE STATE (database-level performance metrics)
  • VIEW DEFINITION (procedure/view/function definitions)
  • SELECT on system catalog views (system metadata access)

Quickstart

  1. Open the target module (Dashboard, Object Explorer, Query Statistics, or another module).
  2. Set filters and scope (time range, object type, search, or severity).
  3. Run analysis or refresh data.
  4. Review findings and supporting evidence.
  5. Export report/script output when needed.
Tip
Start with Local mode (default). No prompts or context leave your network.
Open the quickstart guide

Modules

Each module is designed for a specific operational question. Start with the module that matches your immediate need.

Dashboard

Monitor server health, memory, IO, TempDB, and workload trends in real time.

Query Statistics

Analyze high-impact queries with trend, risk, and plan stability indicators.

Index Advisor

Prioritize index actions, generate maintenance scripts, and export reports.

Blocking Analysis

Visualize blocking chains, identify head blockers, and export audit snapshots.

Wait Statistics

Categorize waits, set baselines, compare snapshots, and export findings.

Security Audit

Run read-only security checks and export HTML audit outputs.

Scheduled Jobs

Track SQL Agent job health, failures, and runtime behavior.

Object Explorer

Browse procedures/views/functions, inspect source, and run AI Tune per object.

Settings & Info Bar

Manage DB/AI/license settings and switch active server, database, and model quickly.

Standard Analysis Workflow

  1. Connect and verify active context from the Info Bar.
  2. Run module-specific analysis (query, index, blocking, waits, or security).
  3. Validate evidence and confidence before applying changes.
  4. Export report/script outputs for review and audit traceability.