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

Tracking SQL Server Configuration Across All Your Servers Using SQL Monitor

The Estate Configuration reports SQL Server configuration across all your servers, so you can quickly investigate ad-hoc or unauthorized changes to any settings that might affect their performance, stability, or security. Read more

Ten Reasons your SQL Server Monitoring will Scale

This article explains ten ways that SQL Monitor tackles the problem of scaling out the coverage of a single, lightweight monitoring system, and so allows your teams to maintain the health and performance of larger collections of databases and higher numbers of monitored SQL servers. Read more

SQL Server Licensing and SQL Monitor

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 SQL Monitor to find out. Read more

Migrating SQL Monitor’s Base Service to .NET Core

Josh Crang explains why SQL Monitor will be switched to run on .NET Core, and how the team tested the potential performance improvements in the monitoring service. Read more

The Underground Map of SQL Monitor

The "metro map" of SQL Monitor, with sightseeing tips and essential stops along every line.... Read more

Using SQL Monitor Groups in PowerShell

Not only are SQL 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 SQL Monitor PowerShell API to export these groups, save their settings onto a configuration management system, or compare groups of settings to see the differences between them. Read more

Tagging SQL Server Changes in SQL Monitor

How to use RAISERROR() in T-SQL to send annotations to SQL Monitor, so you can observe the direct impact of application tasks, or server changes, on the SQL Server metrics. Read more

Monitoring SQL Server with Splunk and SQL Monitor

Splunk is a search engine for collecting and analyzing all sorts of "machine data", including log data and metrics for SQL Server. SQL 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 SQL Monitor to help you understand the behavior of a complex database system such as SQL Server, then you have a powerful and capable monitoring tool set. Read more

Monitoring your Servers and Databases with New Relic Infrastructure and SQL Monitor

New Relic Infrastructure is a capable server monitoring tool but adding Integrations provides only 'bare bones' monitoring for SQL Server. Grant Fritchey argues that to "instrument" a complex system such as SQL Server, effectively, you also need a tool that is built specifically for this purpose. Read more

OVERVIEW

BY NEED

BY ROLE

BY INDUSTRY

Product articles
SQL Monitor
Monitoring Large Estates