SQL Planner, free and professional edition, lets SQL DBA to do following:SQL planner has solutions to manage, monitor, analyze SQL server Health with 50+ reports, receive alerts, Advance Backup option (including objects or tables level) with auto restore and validate option, Index Maintenance jobs, all from single application which can be operated from any device with ease.
How SQL Planner is different: It is browser base and gives flexibility to work even if users are traveling or walking.Monitoring and 50+ health analytical reports - Live and Historical data.Backup feature - has flexibility to auto restore on test server and validate backup file.Backup is even available at selective tables / objects level in the script mode with compression.SQL Index Analyser - live and automation. Supports all SQL edition (including Express) - Task automation feature is independent of SQL Agent.Low Cost - price is 80% low compare to other tools. Free to use up-to 5 monitoring instance or jobs - dedicated to express edition users.
How SQL Planner Works.SQL Planner can be installed on your local machine having Microsoft windows Operating system, and provide SQL server credential (ensure it has Server view state permission or higher privilege, preferably Sysadmin) which has to be monitored or analyzed for health. SQL Planner starts collecting performance and server usage data very efficiently, ensuring your SQL runs smoothly, it also alerts you by email on several critical factor when encountered such as continuous high CPU, RAM, DISK usage, Database or drive space usage etc. SQL Planner instance can be used from browser (Firefox Mozilla preferred) by accessing link: localhost/SQLPlanner , same can be accessed by anyone in your network without installing in another machine, or through Mobile device.
