Tag: Redgate Monitor

One of the things that I think is neat is that Redgate Monitor helps you track patching on your systems. This is something that has been challenging in every position I’ve had, with some systems being forgotten or remaining unpatched for too long.

This post looks at how you track patches and versions.

This is part of a series of posts on Redgate Monitor. Click to see the other posts

The Challenges of An Estate

There are two aspects to tracking your systems: the version and the patch level. Microsoft releases versions periodically and unless you’re in the cloud with a PaaS service, you may or may not have just one version of your database platform. Azure SQL Database is evergreen and updates every quarter or so.

If you install SQL Server 2016, unless you upgrade, it stays at 2016.

The second part is the patch level. SQL Server 2016 has had 3 service packs, multiple CUs in between those, and a few post-SP3 security patches this year (2024). Are you up to date?

It’s a good question since you might be vulnerable to issues, and you certainly can be out of compliance with auditors if you aren’t patched.

What Systems Are Behind?

The estate tab has a versions page, in which we list the installed versions of SQL Server. I hope PostgreSQL is coming soon as well (and others). Here is the overview, where you can see this estate spans SQL Server 2008 R2 to 2022, and includes the cloud.

This helps me with upgrades, as I can see which systems might be old and in need of an upgrade plan. I can filter at the top for different groups, tags, etc., but I can see what I have, and I get quick links to the current patch.

Below this, I have details. Here is where I can dive down to individual groups and systems to see if they are patched, how long ago the last patch was released, and the end of support

This is a good way for me to see at a glance how patched I am. The yellow up arrows mean I need to patch. The green check mark means I am patched.

This is a good view so you can tell how out of date you are. It’s one thing if there are patches released within the last month and not applied. It’s another thing when you have systems that are months or years out of date.

Using This Data

This isn’t something I’d check every day or week, but I would set reminders to have this monitored monthly and have plans in place to get patched. While lots of patches might not affect security, they often to affect support if you need it, and certainly these affect compliance and auditing.

Even if no one audits you, if you have an issue and you aren’t patched, someone will use that as an excuse to blame you in some way. Get patched, at least within 60 days if not 30.

BTW, this data is maintained by Redgate and updated as patches are released. Redgate Monitor downloads a file that populates the latest patches for each version. If your Redgate Monitor Base Monitor cannot reach the Internet, you can update this yourself by downloading this file and copying to your system.

Summary

This short posted highlighted what data you get about versions and patches, and my recommendation, which is to review this monthly.

Having Redgate Monitor keep all this for you is nice and helps you keep a healthy, up-to-date estate.

Redgate Monitor is a world class monitoring solution for your database estate. Download a trial today and see how it can help you manage your estate more efficiently.

A customer was asking recently about the RPO for their estate, and I showed them a few things from the Estate tab in Redgate Monitor. This post covers a few highlights.

This is part of a series of posts on Redgate Monitor. Click to see the other posts

Knowing Your RPO

It’s not often I have been asked by a business user about the Recovery Point Objective, though I’ve seen plenty of DBAs ask business people what they want as an RPO. If you don’t know what an RPO is, read this, and then think of this as the amount of data I could potentially lose.

Not that I will, but it’s possible.

In Redgate Monitor, the Estate tab shows you the RPO for all databases, as a graph. I’m showing this one from the demo site at monitor.red-gate.com. As you can see, I have most of my databases with an RPO of 1 hour or less. The vast majority are under 12 hours.

Note: This graph doesn’t include databases that have never been backed up.

This is based on backups, not on clustering or AGs or anything else, but this does let me determine if I think my estate is healthy. I wish I could alert or easily monitor this, but I can see if there are problems.

If I scroll down, I can sort the table of all databases by the worst RPO. I see this, which shows the SSC server at the top.

I’m not worried, as this is an AG setup and the one database is backed up regularly. Obviously we had a hiccup as 3 days is crazy, but I’m confident someone fixed this as I see a lower RPO with the current backups that have been completed.

If I filter by these servers, things look better.

At an estate level, there may be systems with a large RPO. Data warehouses, or reporting systems aren’t backed up as they can be reloaded in an emergency.

This is a good way for you to keep a high level view of your estate. In general, you will get a feel for what the estate looks like and you can drill into individual systems or databases if you’re wondering. I wish I could filter by RPO, but maybe that’s coming one day.

Summary

This section of the Estate tab gives you a high level view of backups and how you’ve configured them. Ultimately your backup schedule is less important than the RPO it produces and this let’s you keep an eye on what the RPO is for everything.

Redgate Monitor is a world class monitoring solution for your database estate. Download a trial today and see how it can help you manage your estate more efficiently.