Supporting a Production Database: What’s Required

How to plan for an effective response to database problems, as part of a broader, 'tiered' monitoring strategy for production systems, where the process to resolve any known or routine problem is provided alongside the associated alert, and any urgent issues that can't be fixed, or threaten the quality of the service, are escalated promptly to the right team. Read more

Database Monitoring for Developers

Database monitoring is an essential part of database development and testing because it will reveal problems early and allow you to drill down to the root cause, as well as look for any worrying trends in behavior of the database, when under load. If you are delaying doing this until a database is in production, you're doing it wrong. Read more

Six Things to Monitor with PostgreSQL

This article describes six performance metrics that ought to be central to your PostgreSQL monitoring strategy. By using a tool like SQL Monitor to track these metrics over time, and establish baselines for them, you'll be able to spot resource pressure or performance issues immediately, quickly diagnose the cause, and prevent them becoming problems that affect users. Read more

A First Look at PostgreSQL Monitoring in SQL Monitor

PostgreSQL monitoring is now supported by Redgate SQL Monitor to improve performance and reduce downtime. Read more

Finding and Tuning Expensive Stored Procedures using SQL Monitor

SQL Monitor's Top procedures list makes it simple to find the procedures having the biggest impact on performance, allowing you to prioritize your tuning efforts, reduce risk and keep pace with the requirements of your growing database estate. Read more

Improving the Quality of your Database Monitoring

Database monitoring should be as simple as possible, and yet still allow the users to drill into sufficient detail to be able to recommend a fix to the problem. The trick is to adopt a layered or 'tiered' approach. Read more

Monitoring Azure SQL Database with SQL Monitor

Grant Fritchey explains the Azure-tailored metrics and alerts that you need to diagnose performance problems with your Azure SQL Databases, and let you know which resource (CPU, data IO or log IO) is the bottleneck. Read more

Tracking Queries in Redgate SQL Monitor

SQL Monitor v12.1.28 has added functionality to track queries. This blog post will outline what this does and how it works. What is a tracked query? Tracked queries is a new feature on the Server Overview page for SQL Monitor. It was added in preview in SQL Monitor v12.1.28. This feature allows you to mark Read more

SQL Monitor’s new Current Activity page

We recently released a minor version of SQL Monitor, v12.1, that includes Tagging and a new ‘Current Activity’ page. This blog post will outline the latter feature. What is the new Current Activity page? SQL Monitor provides a lot of information on individual servers collected through our samplers which run periodically. That information is useful Read more

Top Query Search in SQL Monitor

SQL Monitor v12.0 has added a new Query Text Search feature to allow users to search the text of the most expensive queries that executed on a SQL Server instance over a period. Here's what it does, and how it works. Read more

OVERVIEW

We’re here to help

BY NEED

BY ROLE

BY INDUSTRY

Product articles SQL Monitor