Home > DBA Stuff, Optimization Performance, SQL Server > SQL Planner, a monitoring tool for SQL Server for DBAs & Developers

SQL Planner, a monitoring tool for SQL Server for DBAs & Developers

SQL Planner is a Microsoft SQL Server monitoring Software product that helps DBA or Developer to identify issues (for ex. High CPU, Memory, Disk latency, Expensive query, Waits, Storage shortage, etc) and root cause analysis with a fast and deep level of analytical reports. Historical data is stored in the repository database for as many days as you want.

About SQL Planner monitoring tool, watch the intro here:


SQL Planner has several features under one roof:

– SQL Server Monitoring
– SQL Server Backup Restore Solution
– SQL Server Index Defragmentation Report and Solution
– SQL server Scripting solution
– DBA Handover Notes Management

Features and Capabilities:

SQL Planner is mainly built for the Monitoring feature and has several metrics as below, their details are available here:

– CPU & Memory Usage reports, Expensive Query and Procedure
– Nice visualization on CPU , Memory , IO usage , expensive query details
– Performance counters Reports
– IO Usage Analysis
– Deadlock & Blockers analysis
– Always On Monitoring
– SQL Server Waits analysis
– SQL Server Agent Job Analysis
– Missing Index analysis
– Storage analysis
– SQL Error Log Scan & Report
– Receiving Alerts: There are 50+ criteria when the Notification is sent via email and
maintained in SQL Planner dashboard too, more details here.
– Handover Notes Management


Absolutely forever free to students , teachers and for developer/ DBA in development environment.

Some screenshots of the tool capabilities:

This slideshow requires JavaScript.


  1. Major
    February 24, 2023 at 5:57 am

    Hello Manoj, Your videos on YouTube are great, but I would like to ask for a favour if possible, to create some videos on some advanced sql server concepts difficult to find:
    1. Update and Delete statements on 5 or more Normalised tables,
    probably using joins over foreign keys.
    2. how to create views and groups of Users in a database.
    3. creating a set of transactions using TCL
    4. Implementing Triggers on tables
    5. Creating scripts to automatically backup and restore databases
    6. Select statements using all clauses to select a particular
    row/rows on 5 or more Normalised tables, probably using joins
    over foreign keys.
    7. The implementation of all these using a particular programming

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: