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
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
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
| Requirement | Specification |
|---|---|
| OS | Windows Server 2012+ or Windows 8, 10, 11+ |
| Disk | SSD or equivalent I/O speed disk |
| Memory | 16 GB RAM or higher (trial: 6 GB minimum) |
| CPU | 4 cores or higher (trial: 1 core minimum) |
| IIS | IIS service configured on the host |
| SQL Server | SQL 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
Download the setup file
Download SQL Planner Enterprise from the Download page.
- 2
Extract and run the installer
Extract the ZIP file and run SQLPlanner_Setup.exe.
- 3
Accept the license
Agree with the license terms and click Next.
- 4
Enter repository SQL Server details
Enter your local SQL Server name and SA credentials to create the repository database, then click Install.
- 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
Open Create Monitoring
Go to Menu → Create Monitoring, or open Health Analysis Job.
- 2
Connect to SQL Server
Enter the SQL Server name and credentials (SQL user with sysadmin or CONTROL SERVER permission).
- 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).
