Mark Champion, Product Marketing Manager at Redgate, talks you through the major new features in SQL Monitor 6, including:
00:33 New diagnostic interface
03:10 Query plans
To find out more about SQL Monitor, visit https://www.red-gate.com/sql-monitor
Or download it now https://www.red-gate.com/dynamic/products/dba/sql-monitor/download
----- Transcript -----
Hi I’m Mark Champion, one of the team behind SQL Monitor. We have recently released version 6 of our SQL Server monitoring and alerting tool, SQL Monitor, and I want to show you what’s new, what’s great and how SQL Monitor can make your job easier.
In version six we have make it quicker and simpler to diagnose the cause of problems affecting a server. The main changes you will see are centred on the server/instance overview, which we get to by clicking here.
In previous versions the information was displayed across a variety of screens, and it could be fiddly to jump between them to get the information you needed. In version six we’ve brought all that information together into this one server overview.
Starting at the top of the page there’s an overview graph showing four key metrics for this server, the CPU and Memory usage, Disk I/O, and Waits. These can all be turned on and off like this.
We can also baseline any of these, based on the previous 7 periods. By default this graph shows the past 24 hours, but you can look at longer or shorter periods like “The last 6 hours” or “the Last 2 days”, and of course, you can rewind time as in previous versions.
Another thing you’ll notice is that underneath the graph there are small circles. These indicate alerts that happened over your select period and they are colour-coded according to severity. If I hover over the circle I get a brief description and if I click it, I can see the details for that alert in this right-hand-side panel. I can also now directly clear the alert from here, or jump straight to that alert’s settings. This makes it easier to clear and tune alerts as they arrive.
Having the alert information on the same page as the metrics gives you additional context so you have a better understanding of exactly what was going on with your server.
You’ll see on the overview graph, there’s a highlighted window in white. This is the “Focus Window”. We can move it around or resize it using the handles. Everything below that graph now updates to look at just that narrowed time window that we have selected. For example, I might want to take a look at this spike in CPU usage from this morning. The 4 graphs below break out those metrics further, and let you see some finer detail which isn’t visible on the main graph above.
All the other metrics you will see below are also tied to the period selected in the Focus Window.
So first we have Top Queries and Top Waits ( I’ll come back to the top queries section in a moment) , but scrolling down or using the navigation on the left here, we can see various other metrics you’d expect from the previous version, including general metrics, processes, the error log and databases. We can click any of the databases here and see full details for that database appear.
Jumping back up to the top to the top queries list, we can see another major new enhancement. If we choose to look at this most expensive query, we can see a new query plan button.
We automatically pick out expensive operations which you can jump straight to by clicking here. We also automatically pick out certain warnings for you. Here for example, we show that there was an operation with no join predicate, which is the reason this query runs slowly, and can be used to understand how the query could be rewritten better. We’ll also warn about things like missing indexes, and give you the script to create those indexes.
Version six of SQL Monitor now helps you get the answers to a whole range of SQL Server problems in a faster, easier and simpler way. Try it for yourself by clicking the download link in the description below and get a free 14 day trial.
If you have any questions, feel free to email [email protected]
Thanks for watching and remember to subscribe.