Skip to main content
SQL Planner

Installation

SQL Planner Pre-requisite and Installation

Self-installation instructions, software and hardware requirements, required permissions and first monitoring job setup.

Updated

SQL Planner self-installation

  1. 1

    Install IIS

    Configure the IIS service on the host machine before running the SQL Planner installer. Watch the step-by-step “How to Install IIS” guide in the installer documentation.

  2. 2

    Install the application with an SA account

    Run the installer using SQL Server SA credentials (or equivalent). Watch the “Installation with SA Account” guide in the installer documentation.

Software & hardware requirements

RequirementSpecification
OSWindows Server 2012+ or Windows 8, 10, 11+
DiskSSD or equivalent I/O speed disk
Memory16 GB RAM or higher (trial: 6 GB minimum)
CPU4 cores or higher (trial: 1 core minimum)
IISIIS service configured on the host
SQL ServerSQL Server 2012+ for the repository (trial: SQL Express is OK)

Required permissions

Host machine

Administrative rights on the machine where SQL Planner will be installed.

SQL Server

Sysadmin or CONTROL SERVER SQL Server user credentials for the repository and for monitored instances.

Steps to install SQL Planner

  1. 1

    Download the setup file

    Download SQL Planner Enterprise from the Download page.

  2. 2

    Extract and run the installer

    Extract the ZIP file and run SQLPlanner_Setup.exe.

  3. 3

    Accept the license

    Agree with the license terms and click Next.

  4. 4

    Enter repository SQL Server details

    Enter your local SQL Server name and SA credentials to create the repository database, then click Install.

  5. 5

    Watch the process walkthrough

    Follow the installation video in the installer documentation while the setup runs.

Download SQL Planner

Get SQL Planner Enterprise, DB Health Pro and related tools.

Steps to create a SQL Server monitoring job

Initial login

Navigate to SQL Planner. Use the default user ID Admin and password Admin.

  1. 1

    Open Create Monitoring

    Go to Menu → Create Monitoring, or open Health Analysis Job.

  2. 2

    Connect to SQL Server

    Enter the SQL Server name and credentials (SQL user with sysadmin or CONTROL SERVER permission).

  3. 3

    Set thresholds

    Once connected, specify threshold definitions. SQL Planner has 100+ alerts — about 15 are shown on the page; the rest are sent automatically.

Email setup

Add your user email ID. You must define your DB Email setting in SQL Planner. By default it uses the Elastic Email API (third party), which we do not recommend for production.

Configure Email Alert

Full guide to linking email alerts with SQL Planner.

Windows Server monitoring configuration

After installation, configure Windows Server monitoring using the post-installation Server Monitor Configuration Guide.

Windows Server Monitoring

Product overview for resource, event log and alerting features.

Download this guide as PDF

SQL Planner Pre-requisite and Installation (original PDF).