Product Features

SQL Planner boost SQL Server Administration with following features

Server Alert , Monitoring, Health Analysis, Space Analysis:
The feature allows you to monitor, get alert when high CPU, RAM, SPACE shortage, Server down etc
DBA can easily analyze, based on historical data, the trend or pattern when resource utilization is going high, locks count, Query behind it,data or log file exceeds to specific size and so on. Which helps DBA to become proactive and making server performance faster there by saving you cost from buying new server.
Setting Alert on Database server
Do you wish to get alert when your server is down, when database data or log file exceeds to specific size, when CPU / RAM / Disk usage exceeds to specific threshold values, it can send you email about it and post details about it Server health report section.
When alert are defined on specific server, it also gets server health related Meta data and allows you to analyze historical server resource usage, bottleneck, expensive query by CPU / IO etc without connecting to your SQL server and thereby saving server hits and access from one location.
Feature booster to SQL Server Express edition:
SQL server express edition always comes without Agent – which has scheduling jobs capability, without Maintenance plan – having several plans like automatic Backup , Index maintenance , Shrink Database , update statistics , Notify operator , Execute T-SQL Statement etc.
With SQL Planner, you can do all above task without your complex own scripting code. Apart from this, it also allows you to view automatic track on Health status and monitoring and alert on specific events – specific threshold CPU, RAM , Disk, Database space, Server Heartbeat usage , which is very light weight. Visit to Feature Page to know more.
Backup and Restore
Perform Database Backup to server disk, shared disk or ftp location and automate it, delete backup file after specific days , you can browse remote server disk location.
Perform Database Backup to server disk, shared disk location and automate it, delete backup file after specific days, you can browse remote server disklocation.
Automated Database Scripting and Sync
Allows you to generate SQL server database script and automate it, a unique feature, save as .sql file in SQLPlanner server disk, optionally you can sync this database script to other server.
Index Maintenance, Shrink Database, update statistics Maintain Indexes, Shrink databases, update statistics and schedule it, organization running SQL express edition loves these feature.
SQL Server version and edition supported 2008 R2, 2012, 2014, 2017, 2019, all editions including express.
License Option:
SQL Maintenance planner Web application will always be free, automation / Scheduling feature comes with 4 months of trial. Allowed for Unlimited server and instance, unlimited users and unlimited jobs. Upcoming features: Below feature are my roadmap for next 2-3 years.
  • Several Health Reports addition on health
  • Several addition on alert, missing index suggestion etc.
  • Edit feature of all jobs and alerted server.
  • Auto backup file restore to other server.
  • Advance Options on Index maintenance.
  • Schema comparison.
  • Query Editor and execution.
  • that most of DBA will Request or vote.
  • Application look and feel enhancement.