Try Spotlight Cloud ProSign in

      Introducing New Feature: Always On Availability Group

      By: Martin Wild

      As a SaaS product, Spotlight Cloud Professional is constantly updating so that users have access to an optimal tool. We regularly release new features that make our database performance monitoring tool one of the best out there. And recently, we just released our latest feature – Always On Availability Group. Continue reading to learn how it works.

      Here, we’ll walk you through how Spotlight Cloud monitors the health and status of always-on availability groups. As the data is collected, we've obviously got information that will allow us to generate alarms if there's any health issues with your availability groups. Let's quickly take a look at those.

      AOAG1

      If we go to the overall here and look at the alarms, we can quickly pull up alarms relating to always-on availability. So, we have a number of alarms open at the moment. This is where you could come initially to investigate a particular problem.

      AOAG2

      Like in this example here, we've got at least one database that's not in a synchronizing state and on the right-hand side when we select the alarm, you'll see the various different databases, whether they're a secondary or a primary that are not in a sync state.

      AOAG3

      And we see suggestions at the bottom. We can acknowledge or snooze these alarms and we can also see some background relating to that alarm. So, that's where the alarms would appear and we can investigate them and fix the particular issues. But if we wanted to drill in and get some more information, we can do that as well.

      AOAG4

      So, here is particular instance that we're monitoring. If you select Availability in the dropdown, you’re able to see information about availability groups in the availability dashboard.

      AOAG5

      And you can see here with the column here called HA type, that any database here that is part of an availability group, that would be flagged up there and we can see the availability group name and information about the backups.

      AOAG6

      If you select a particular database in the center, you’ll see on the right side an additional column called availability group. This will show you the replica role, the fail over mode, the availability mode, and the health associated with that. You’ll also see some information at the bottom here about the send rate, the redo rate, and the average log send rate at the bottom. So, this is where you can view the health, for example, of the primary.

      AOAG7

      And of course, you can look at this at different time ranges by changing the time zone at the top as well.

      AOAG8

      If you navigate to one of the secondaries of the primary replica, you’re able to do a similar thing here in the Availability area. In the snapshot above, you’ll see the primary replica, and you can highlight that particular database. And on the right-hand side, you’ll can see it's the primary replica role, the fail over mode, and also the information about the secondary replica is at the bottom there. So, we can see information from both sides there, and all those are being monitored for you and would appear as a particular alarm if there was a particular problem in that area.

      For a detailed step-by-step guide, watch the video here.

      Want to see this feature in action? Download our FREE 30-day trial (no credit card required).

      April 23, 2020 7:28:32 AM PDT
      Martin Wild

      Written by Martin Wild

      Sales Engineer at Quest

      Topics