Case 1 - Finding Root cause in a minute !
You were informed about Slowness/ Session Crash/ Un-responsiveness, Lets see it in a video, how quickly SQL Planner can generate the root cause report (Expensive Query, Deadlock, Blocks, CPU & Memory Report)
Case 2 : finding IO usage or Disk latency ?
From Menu – Just 1 click and say Analyze IO and select server and duration :
Quickly pointing list of databases having high latency, any point >30 ms is a point of attention.
Case 3: Finding, Where are the waits ?
SQL Server resource many a times waits for the resources to get free and serve your data, you can find it in few seconds. From Menu, Click Analyze Waits, select Server and duration
Detailed Report shows, Waits duration and by application overall graph. Below has granular level report on Query detail which ran by specific user and application and duration it waited for.
Case 4 – from Where To begin for the Day – Read Alerts
You have 100s of server and Not sure where to start for the day, SQL Planner keeps constantly checking your SQL server health and whenever issue detected, it sends you notification and save in dashboard in Alert detected section. SQL Planner also display root cause and remediation hints for your next step !
Alerts and Remediation
To view Alert detail and remediation, click detailed report. Our remediation is a summarized points is a nice to have a suggestions for most DBAs. How our list of 100+ can help you, please visit to :
https://mssqlplanner.com/alerts-for-sql-server/
Features comparison with other Tools
SQL Planner | Others | |
Monitoring and Deep analytical reports | Yes | Very Few has it |
Agent Job Analysis | Yes | No |
Special Always on Monitoring Dashboard | Yes | No |
Index Fragmentation Analytics | Yes | No |
Backup, Scripting Free tool | Yes | No |
Handover Notes Management | Yes | No |
SQL Server Auditing | Yes | No |
Demo here : https://www.youtube.com/playlist?list=PLhQL4QBn_4IziPwz5y05SS9YXpHsDA7cm
Download here : http://mssqlplanner.com/download-product/
For any support or enquiry, write to : support@mssqlplanner.com