Redgate Hub

Topic: Performance monitoring and optimization

All products

All databases

All levels

Redgate Monitor logo

Cut SQL Server Licensing and Cloud Costs by Monitoring CPU Overallocation

Avoid paying for unused CPU power, on-prem or in the cloud. This guide shows how to use Redgate Monitor to identify overprovisioned SQL Server VMs, reduce licensing and compute costs, and ensure your workloads still run smoothly. Read more

Redgate Monitor logo

Query Executions in Redgate Monitor

Query Executions in Redgate Monitor captures individual query executions for long-running queries, providing deeper insight into database workload and resource usage. This helps DBAs diagnose performance issues with greater accuracy. Read more

Redgate Monitor logo

Dynamic Alerting on Processor (CPU) utilization

This article explores dynamic alerting, what it means, why it matters for DBAs, and how it works in Redgate Monitor. Learn how machine learning-driven thresholds increase alert relevance, helping teams focus on real performance issues while saving DBAs time. Read more

Redgate Monitor logo

Understanding PostgreSQL's Cache Hit Ratio

This article explores PostgreSQL's buffer cache hit ratio (BCHR), a metric tracked by Redgate Monitor to help you assess the health and performance of your databases. By correctly interpreting this ratio and using it with other relevant memory and IO metrics, you can identify potential bottlenecks in query execution before… Read more

Redgate Monitor logo

Better Database Incident Management with Redgate Monitor

This article demonstrates how Redgate Monitor helps teams manage database incidents efficiently, by providing the right data to the right people, at each stage of a tiered incident response system. With fewer distractions from routine issues, specialist staff can focus on core tasks while teams resolve problems faster and prevent… Read more

Redgate Monitor logo

Current Activity for PostgreSQL in Redgate Monitor

Current Activity for PostgreSQL in Redgate Monitor provides a real-time view of queries currently running on your PostgreSQL instances. It will allow you to identify quickly any queries that are currently causing blocking and resource contention issues on an instance. Read more

Redgate Monitor logo

Troubleshooting SQL Server Queries using Actual Execution Plans

For SQL Server 2019 onwards, Redgate Monitor can now show the actual execution plan, complete with runtime statistics, for expensive queries that were running over any period of investigation. This means you'll not only know how SQL Server executed your poorly performing query but also see accurate runtime data. Any… Read more

Redgate Monitor logo

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… Read more

Redgate Monitor logo

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 Redgate 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… Read more

Redgate Monitor logo

Finding and Tuning Expensive Stored Procedures using Redgate Monitor

Redgate 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

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Hub

Topic: Performance monitoring and optimization

Cut SQL Server Licensing and Cloud Costs by Monitoring CPU Overallocation

Query Executions in Redgate Monitor

Dynamic Alerting on Processor (CPU) utilization

Understanding PostgreSQL's Cache Hit Ratio

Better Database Incident Management with Redgate Monitor

Current Activity for PostgreSQL in Redgate Monitor

Troubleshooting SQL Server Queries using Actual Execution Plans

Database Monitoring for Developers

Six Things to Monitor with PostgreSQL

Finding and Tuning Expensive Stored Procedures using Redgate Monitor

2026 State of the Database Landscape

Introduction to PostgreSQL for the data professional

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Topic: Performance monitoring and optimization

Cookies on red-gate.com