Synchronous replicas in SQL Server Availability Groups promise no data loss, but they don’t promise zero delay; under heavy load they can still fall behind. This article shows how to measure and track that hidden replication delay using SQL Server performance counters, so you can see how well your system keeps up during IO‑intensive operations and plan maintenance more safely.
2025-09-17
2025-07-23
2,292 reads
Steve wonders if it is worth it to use multiple monitoring systems for a database.
2025-06-20
129 reads
Monitoring and observability are becoming more important in today's 24x7x365 environment for applications. Steve asks what data helps you solve problems today. Tell us what's important to you.
2024-06-28
186 reads
The rise of cross platform databases which are both on-premises and in the cloud, alongside decreasing customer satisfaction and trust in digital channels, has increased the importance - and value - of enhanced database monitoring. Find out how using a database monitoring tool creates value for the whole organization.
2023-12-08
How do we design a monitoring system? The Amazon Prime team realized they didn't do a good job and changed their architecture.
2023-05-31
166 reads
We need to measure and monitor things to become better, but we need to keep an eye on what the actual goal is from this monitoring.
2023-03-20
151 reads
We need to monitor our servers, but individual metrics have more complexity than just setting simple limits for their readings.
2023-02-06 (first published: 2023-01-30)
305 reads
In this tip we look at how to capture deadlocks that occur in SQL Server and the associated information to help troubleshoot. We look at how to do this using the GUI and T-SQL code.
2022-08-24
Learn about how you can monitor your Azure Storage account and set alerts to let you know when to take action.
2022-07-08
2,726 reads
Do you know if your SQL Server is really running at its best? To...
You can find the slides of my session on the €100 DWH in Azure...
By Steve Jones
This value is something that I still hear today: our best work is done...
Comments posted to this topic are about the item Single User SQL Server on...
Comments posted to this topic are about the item All the Costs of Downtime
Comments posted to this topic are about the item How Well Does the MSSQL...
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers