April 22, 2022 11:44 am
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.
– SQL Server Monitoring
– SQL Server Backup Restore Solution
– SQL Server Index Defragmentation Report and Solution
– SQL server Scripting solution
– DBA Handover Notes Management
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.
Posted by Manoj Pandey
Categories: DBA Stuff, Optimization Performance, SQL Server
Tags: SQL Planner, SQL Server DBA
Mobile Site | Full Site
Get a free blog at WordPress.com Theme: WordPress Mobile Edition by Alex King.
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
language.
By Major on February 24, 2023 at 5:57 am