...in fact, it's already here! You can download a copy of brand new SQL Monitor 9 either by using the upgrade banner in the product, or downloading it from here.
The marketing launch for SQL Monitor 9 will commence on February 18th 2019, where we will announce all the new features across our usual channels. I wanted to give you a preview of everything we're announcing so you can be the first to try it out.
As always, all these new features are also available to try through our online demo at monitor.red-gate.com.
What's included in SQL Monitor 9...
Estate Management
Estate Management lets you monitor your estate across four new views: Installed Versions, Disk Usage, Backups, and SQL Agent Jobs. Found under the Estate tab each provides a new way to track important metrics across large or growing estates without eating away at your time or the quality of your monitoring.
By regularly checking these views alongside alerts SQL Monitor can give you confidence and clarity when maintaining your estate’s operation and security.
Installed Versions
Identify the current versions for each of your servers.
An overview of all servers above gives an instant breakdown with further information on a server by server basis below, including any new updates and when mainstream support will end. Servers will be flagged by SQL Monitor and a link to the latest available update provided inside the client so help you update as soon as possible.
The information in this view will help you ensure you’re up to date with the latest feature and security fixes while also aiding your patch and upgrade cycle.
Disk Usage
Discover changes in your disk usage on an estate or individual server basis.
You’ll be able to identify unusual changes in disk usage and use trend lines to predict expected disk usage for all your servers. With this you’ll be able to effectively report on disk usage and plan for any capacity or database changes needed.
Backups
Ensure your information is recoverable, with an overview of backups done across your estate.
For each database you can find a history of when each backup was done, time taken, size of the backup, type of backup, and location. You can also find out the recovery model and worst recovery point objective in the last 30 days for each database, telling you how much data you stand to lose if recovery becomes necessary.
This robust history for each database will allow issues to be identified and investigated, along with providing a convenient paper trail for auditing and compliance reporting.
SQL Agent Jobs
Check for issues by showing all jobs that have run in the specified timeframe along with their status.
A summary graph for the previous day, week or month showing number of successful and failed jobs, gives an overall success rate. Drill down on a job by job basis shows when it's next due to run along with a history of past successes and failures, with reason for any failures that you can investigate.
SQL Server estates can have a significant number of jobs running across even a single day so an overview like this one is a must to ensure that everything is running smoothly and any issues found and resolved quickly.
Azure SQL Database support
With full support for Azure SQL Databases you can now monitor and manage your on-premises, cloud, or hybrid estates, all from within one dashboard. Get an overview of your estate by looking at on-premises and cloud severs together or drill down on separate servers for a more detailed breakdown.
With this you can keep all your servers together for high level work such as general monitoring or reporting while still being able to manage and investigate more specialized metrics for different server types. To help you get started when monitoring cloud servers SQL Monitor 9 comes with 14 new alerts and 36 new metrics for Azure SQL Databases out of the box alongside custom metrics support for your more specific needs.
Remember, keep an eye out across the Redgate channels from February 18th for our full launch communications.
...in fact, it's already here! You can download a copy of brand new SQL Monitor 9 either by using the upgrade banner in the product, or downloading it from here.
The marketing launch for SQL Monitor 9 will commence on February 18th 2019, where we will announce all the new features across our usual channels. I wanted to give you a preview of everything we're announcing so you can be the first to try it out.
As always, all these new features are also available to try through our online demo at monitor.red-gate.com.
What's included in SQL Monitor 9...
Estate Management
Estate Management lets you monitor your estate across four new views: Installed Versions, Disk Usage, Backups, and SQL Agent Jobs. Found under the Estate tab each provides a new way to track important metrics across large or growing estates without eating away at your time or the quality of your monitoring.
By regularly checking these views alongside alerts SQL Monitor can give you confidence and clarity when maintaining your estate’s operation and security.
Installed Versions
Identify the current versions for each of your servers.
An overview of all servers above gives an instant breakdown with further information on a server by server basis below, including any new updates and when mainstream support will end. Servers will be flagged by SQL Monitor and a link to the latest available update provided inside the client so help you update as soon as possible.
The information in this view will help you ensure you’re up to date with the latest feature and security fixes while also aiding your patch and upgrade cycle.
Disk Usage
Discover changes in your disk usage on an estate or individual server basis.
You’ll be able to identify unusual changes in disk usage and use trend lines to predict expected disk usage for all your servers. With this you’ll be able to effectively report on disk usage and plan for any capacity or database changes needed.
Backups
Ensure your information is recoverable, with an overview of backups done across your estate.
For each database you can find a history of when each backup was done, time taken, size of the backup, type of backup, and location. You can also find out the recovery model and worst recovery point objective in the last 30 days for each database, telling you how much data you stand to lose if recovery becomes necessary.
This robust history for each database will allow issues to be identified and investigated, along with providing a convenient paper trail for auditing and compliance reporting.
SQL Agent Jobs
Check for issues by showing all jobs that have run in the specified timeframe along with their status.
A summary graph for the previous day, week or month showing number of successful and failed jobs, gives an overall success rate. Drill down on a job by job basis shows when it's next due to run along with a history of past successes and failures, with reason for any failures that you can investigate.
SQL Server estates can have a significant number of jobs running across even a single day so an overview like this one is a must to ensure that everything is running smoothly and any issues found and resolved quickly.
Azure SQL Database support
With full support for Azure SQL Databases you can now monitor and manage your on-premises, cloud, or hybrid estates, all from within one dashboard. Get an overview of your estate by looking at on-premises and cloud severs together or drill down on separate servers for a more detailed breakdown.
With this you can keep all your servers together for high level work such as general monitoring or reporting while still being able to manage and investigate more specialized metrics for different server types. To help you get started when monitoring cloud servers SQL Monitor 9 comes with 14 new alerts and 36 new metrics for Azure SQL Databases out of the box alongside custom metrics support for your more specific needs.
Remember, keep an eye out across the Redgate channels from February 18th for our full launch communications.