Tag: Redgate Monitor

Earlier this year I visited a customer that was using the Redgate Monitor webhook to integrate with ServiceNow. However, they were also trying to integrate in a richer way to create incidents and a richer experience.

We took that as a bit of feedback and recently released native ServiceNow integration to allow updates to incidents as status changes. Automatically.

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

New Native Integration

Redgate Monitor originally only integrated natively with PagerDuty. Over time, we’ve add other ways to connect to other systems and send alerts or data to them. Slack and webhooks were available first , but recently we’ve changed.

If you click the gear icon in the upper right of Redgate Monitor, you’ll go to the configuration screen.

In here, look for the Notification settings. This likely as an “Improved” tag if you look at it in late 2025. Click this.

On the Notifications settings page, you see email settings at the top. Most customers configure this as email is still a great way to capture alerts and handle routing of info to a team.

If you scroll down then you see the other types of notifications. Slack has been there for some time, and if you click this, you see the details you can configure.

The new alert sinks are ServiceNow and Microsoft Teams. If I click the ServiceNow item, I see some details. I can enter my ServiceNow URL and the API key to connect. I can optionally also close an incident if the Alert ends. That’s always helpful.

Microsoft Teams is similar. Here I’m just sending messages, as I do in Slack. I can enter the URL, which would be for the location I want messages sent. I can optionally send a message when the Alert ends.

We still have the Webhook settings as well, so you can send to your orgs messaging system (Slack/Teams) and another location with a Webhook if you want. This might be useful for a different system or perhaps a dashboard where you are tracking information about databases.

Redgate Monitor has grown to add these new options to give you the flexibility you need to handle alerting staff about database issues.

Summary

Managing a large estate is hard, and it is incredibly helpful to have tools to organize, track, and share information. Redgate Monitor is a great platform for this, and with these new integrations, it can be used alongside existing tools to prevent you from missing any of those important alerts.

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 wanted a report they could email to their boss about jobs, something that showed failures. This isn’t hard to get in Redgate Monitor, though it is manual (for now). Here’s how to do this.

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

The Estate View of Jobs

Under the Estate menu item, there is an entry for jobs.

Click this and you get to the estate view of jobs. Here I see an overview, and I can click the scale in the upper right for day/week/month.

Below this I see the failed and successful job details, though only for the most recent execution. Otherwise this is a ton of data. Good to note that the 10 jobs that failed must have succeeded on a subsequent run.

There is a button to see the details. Click Export:

This downloads an Excel sheet of my jobs. There is a summary tab of the status with some details by day.

In the job details, I see the last run status for jobs. In this case, I don’t have any failed jobs (last run). However, I downloaded this earlier in the day, when I did have a job that failed in its more recent execution. Here’s what I see in the details if I scroll across. Look at the top line, which is the failure.

I can see the reason the job failed and the date/time.

If I were grabbing this every day, I’d have a nice report of how things are going. I would like to see a more detailed version of a report, and if you want it, please email sales@red-gate.com and request it.

Summary

Getting reports to share with others is important. As much as I’d just like to get people to look at the tool, I do understand having periodic reports. I used to self-generate these and store them off in a secure place. These were invaluable for auditors and kept them from asking me lots of questions.

You could do this as well, and Redgate Monitor makes it easy to get this info. Look for enhancements in this area in the future that might help you with estate level reports for your management (or auditors).

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 about how to track all the stored procedures that execute on their system. We have a section in Redgate Monitor that’s set to look at stored procedures, and you can easily find information about them.

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

Finding Stored Procedures

If I go to the SQLServerCentral_Test system on monitor.red-gate.com, I can scroll down and see the top queries for the time period selected. Here’s an example of a query. The main query window shows SQL, but these are parts of procs.

If I expand to the full query, we see this is part of a proc. That’s good, in that if the query causing problems is part of a procedure, I can track that down.

However, what if I know people are reporting a problem that is related to this proc. Can I find it knowing the name? I can’t in the Top Queries.

However, we’ve added a Top procedures item to the right. That’s the place to focus on if you use stored procedures. And you should, since they create a looser coupling between your schema and the various business things your app needs to do.

On this test system, there are relatively few procedures running, but on many systems in production, this is a large list of things. To the right (not shown) there are various metrics that help you determine which of these items might be stressing your system because of execution counts, duration, CPU, etc.

If I know I have a procedure, I can search using the box. Here, I’m searching for UserA, but you might be searching for FinanceReport, hoping to find which of the FinanceReport_A, FinanceReport_B, FinanceRepot_Prep, etc. procs is using resources.

Expanding any of these (clicking the arrow) gives you more detail, as you would get in the Top Queries section.

Summary

Tracking down which queries are stressing your system and why can be hard. We added the focus on procedures as this is an easier way for some customers to determine what part of their workload is causing issues. In the top queries, sometimes procedures get lost, so this section lets you drill down into how your system is performing.

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.

During a demo of Redgate Monitor Enterprise to a customer, they asked about how to search for permission changes. This post examines how you can do that in Redgate Monitor.

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

Permission Changes

Redgate Monitor Enterprise adds a few security features to the tool that track things that organizations can struggle to track as their estates grow. There is a security menu item at the top of your Redgate Monitor web page. You can see this expanded on our demo system at monitor.red-gate.com.

Click the permission entry and you will see this starts on a page that is titled Permissions. There are a few tabs below the title (Permission changes, Servers, Databases, Users). We start on Permission changes, which helps us to see the various changes that have occurred.

Below this, we see a date box that is set for the last week, along with a few other items. By default we show you the last week’s worth of changes and all the data. However, you can easily alter this.

This can be a lot of data, especially in an enterprise, so perhaps I only want to see certain things. I can click “Columns and choose which data I care about. Here, I’ll uncheck a few boxes.

Notice this has rolled up some changes, so I don’t see quite as much as data as I do in the default view. This is useful when I want to see the “who had a change” and not every detail.

I can, of course, change the date range. We give you some quick defaults, or you can use the calendar picker to choose a range.

When I do this, I only see some changes, those that apply to that date range.

If I want to further filter things, I can choose that item. You can see the various items below I can choose from.

Let’s set  this to “Changed by” the sa account. When I do that, notice the “Filters” icon is annotated saying I have 1 filter condition. I also only see the one row changed by SA.

I will expand my date range and remove the filter while adding all the columns, and I see this data:

That’s a lot, but I can change the density. Here are the choices.

Here is compact. Now all 10 rows fit on the page:

Comfortable only shows 7 rows (9 in standard).

Lastly, I can set the number of rows on the page in the lower right.

Summary

Security is becoming something more people need to report on, especially public companies or those regulated. This feature of Redgate Monitor helps you satisfy auditor requests with the information they need to verify you are watching your systems.

Or, at least that you know Redgate Monitor is doing so.

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.