1. Monitor SQL Server
2. Analyze the health
3. Audit SQL Server
4. Backup & Scripting
5. DBA Handover Notes Management etc.
- Central Management From Any Device.
SQL Planner is versatile and adaptable, catering to various environments. Whether your MS SQL Server is on-premise, operating as a VM in the cloud, running on a Linux OS, or utilizing a SQL PAAS DB model like Azure/RDS, SQL Planner provides comprehensive support for all these scenarios from a centralized location.
Key features of SQL Planner encompass simplicity, speed, direct identification of the root cause, affordability, and immediate support.
SQL Server Activity Monitoring tool - Report List
CPU & Memory Usage reports
1. SQL process, Non-SQL process and Total CPU Usage based on hourly aggregated and per minute wise.
Performance counters Report
performance counter reports are generated based on average aggregation at a time-frequency when data are pulled from SQL Server.
1. Average connection counts Database level and server level
2. Database page usage, Cache Page, SQL Cache memory usage
3. Buffer Cache Hit ratio, Check point page per second
4. PLE number, Lock Memory, Buffer pool memory, Lazy write Per sec
5. Batch Request, SQL Compilation and recompilation
IO Usage Analysis
Overall IO Usage by Database
IO Usage by database logical database file
Read, Write, Latency by DB wise
Deadlock & Blockers analysis
Hourly Count, Duration by Database and object wise
Details of victim Query and Root cause query session at a granular level
SQL Server Waits analysis
Identify SQL Queries with Wait type and Wait Duration based on following :
1. By Applications
2. By Databases
3. By Users
4. By Wait or Wait Types etc
Query Mining Solution
Identify quickly those SQL Queries having
1. Implicit Conversion
2. Index Scan
3. Missing Index
Which helps to boost SQL Performance by 2x - 10x plus faster than current speed, depending on number of Query execution count and number of such SQL Query.
Expensive Query and Procedure
Easily Generate Reports on expensive SQL Queries, Stored Procedure by overall wise , by IO , by CPU , by Application, by User, by Database etc.
Storage analysis
Overall Disk Size utilized vs free space
Databases wise total size growth trend graph
Disk drive usage growth analysis trend
Receiving Alerts
100+ customized alerts. For example Notification email triggers when
when your server is down
when database data or log file exceeds a specific size
when CPU / Memory usage exceeds to specific threshold values
When Disk shortage detected
any word occurrence of errors/warning/terminate/dead in SQL error log found, etc
SQL Server On Premise/ VM - Alert List here
Azure / RDS PAAS SQL Database - Alert List here
SQL Error Log Scan & Report
SQL Server Error Log report based on error occurrence
Server connectivity failure or success report
SQL Server Agent Job Analysis
SQL Server Agent Job Analysis by duration or historical check
Alerts on failure or Cancellation.
Always On Monitoring
SQL Server Always On Live & Historical Dashboard to monitor All of AG Groups, Replica Health & Status from All Server.
Alerts on failure or Sync Issue.
SQL Server Auditing
- know who and when Created, Dropped, Alter Database , Schema or Any objects
- Know Who and when executed DDL, Login, DBCC, Server state DMV or admin Operational Command
- Know malicious Login attempts etc..
Demo Here
Azure SQL DB Monitoring
Azure SQL DB or PAAS SQL DB complete Monitoring
Details and Demo Here
Task / Handover Notes Management
DBA Handover Notes central management, tracking, editing in SQL Planner and same is Forwarded to Email as well
Demo Here
SQL Monitor Reports Screen Shot
