SQL Performance Intelligence
SQL PerformanceIntelligence™

Documentation

Practical setup and module usage guide for SQL Performance Intelligence — install, connect, and run your first evidence-backed analysis.

Getting Started
OverviewInstallationQuickstartSettings
Modules
DashboardQuery StatisticsIndex AdvisorBlocking AnalysisWait StatisticsSecurity AuditScheduled JobsObject Explorer

Before You Begin

Use this page as the navigation hub. For the best user and SEO structure, each guide below has a distinct job: Overview explains the product, Installation covers setup and prerequisites, and Quickstart walks through the first working analysis, while Settings documents the configuration surface that controls SQL, AI, license, and appearance behavior.

Overview

Read this first if you want to understand what the product does, why Query Store matters, which AI path to choose, and which modules to open first.

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 this guide for Windows installation, first-run onboarding, SQL login preparation, Query Store enablement, and the initial Database plus AI / LLM setup.

# 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; for the exact setup sequence and DBA examples, use the installation guide.

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

Use Quickstart after installation when you want the shortest path to a working SQL connection, a tested AI provider, and the first real Dashboard or Query Statistics review.

Tip
Start with Local mode (default). No prompts or context leave your network.
Open the quickstart guide

Settings

Use this guide when you need a full explanation of the Settings window, including SQL connections, AI providers, licensing, local app lock, cache behavior, thresholds, and appearance preferences.

Best Use
Read this after installation if you want to understand what each tab changes before editing advanced options.
Open the settings guide

Modules

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

Dashboard

Refresh a current snapshot of server health, memory, IO, TempDB, and workload pressure for the active connection.

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.