Phil Factor sets out with the modest aim of giving you enough of an introduction to waits to better understand the wait information you get from a SQL Server monitoring tool like Redgate Monitor, and the rather overwhelming amount of information available in the underlying DMVs and Extended Events.Read more
Jamie Wallis explains how Redgate Monitor can both reveal quickly who ran a deployment, and when, and automate the incident-response workflow to ensure it's dealt with swiftly. By extending such workflows to development and test servers, as well as production, the feedback cycle starts earlier, and you can stop problems…Read more
How well do the SQL Server licenses you own match up with what you need for your current use? William Durkin explains how to use Redgate Monitor to find out.Read more
Phil Factor on the fill factor, pages splits and index fragmentation, and how Redgate Monitor can help you decide if a custom fill factor for certain indexes might help alleviate performance issues.Read more
Redgate Monitor 10.0.5 now supports a user role called "Reports user". A user added to this role, by an administrator, will be able to 'self-serve' Redgate Monitor reports but won't be able to configure any other aspect of the monitoring service. Jeremiah Peschka explains how it works.Read more
Not only are Redgate Monitor Groups probably the neatest and most maintainable way of ensuring that all your SQL Servers have the best possible configuration of alerts, but they represent a powerful way of categorizing your SQL Server estate. In this article, I'll show how to use the Redgate Monitor…Read more
How to use RAISERROR() in T-SQL to send annotations to Redgate Monitor, so you can observe the direct impact of application tasks, or server changes, on the SQL Server metrics.Read more
You need to make sure that nobody tampers with your production databases, or really any databases outside Development. Even if you weren't of a nervous disposition, you'd want to know if a database was stopped or removed. You'd also be intrigued by the sudden unrehearsed addition of a database to…Read more
Splunk is a search engine for collecting and analyzing all sorts of "machine data", including log data and metrics for SQL Server. Redgate Monitor gives you the detailed diagnostic view of all your SQL Server instances, and databases. If you have Splunk to monitor your applications and server infrastructure, and…Read more