Product articles Redgate Monitor
Investigating problems with ad-hoc queries using SQL Monitor
Phil Factor demonstrates the performance problems that overuse of ad-hoc queries can cause and then how SQL Monitor can warn us when they are the cause of these problems on your SQL Servers, using built-in metrics such as SQL Compilations/sec metric and Batch Requests/sec. Read moreHow to monitor the impact of patching on SQL Server performance
This article uses the Spectre/Meltdown bugs as means to demonstrate how you can use a tool like SQL Monitor to assess the impact of patching on the throughput and performance of your SQL Servers. Read moreHow SQL Monitor Monitors Azure-based SQL Server Failover Cluster Instances
Jon Hayman shows you how to set up SQL Monitor to monitor Azure-based clustered SQL Server instances right alongside your on-premise clusters. Read moreAlert Inbox Grouping Preview in SQL Monitor
The SQL Monitor team are hard at work, improving how you manage your alerts. We’re currently researching whether the ability to see similar alerts grouped together (akin to the threaded email view you see in Gmail or Outlook) might address the common problems we hear on research calls, and on the SQL Monitor UserVoice page. Read moreSQL Monitor Quick Tip: Using the SQL static code analysis performance rules
This quick tip illustrates SQL Monitor's built-in set of Performance Rules for static code analysis. These rules are designed to highlight SQL syntax that could potential cause performance problems, and so indicate ways to improve the overall quality and performance of the workload, over time. Read moreUnearthing Bad Deployments with SQL Monitor and Redgate’s Database DevOps Tools
Sudden performance issues in SQL Server can have many causes, ranging all the way from malfunctioning hardware, through to simple misconfiguration, or perhaps just end users doing things they shouldn't. But one particularly common culprit is when deployments go wrong: I don't know a single DBA who hasn't been burned by a bad release. Read moreSQL Monitor plans for the second half of 2017
SQL Monitor’s dev team has made huge improvements to the product over the last year. In the first half of 2017 alone, they released reporting capabilities, support for collecting metrics from VMWare hosts, significant improvements to performance and scalability, improved configurability of alerts, as well as dozens of smaller enhancements. Since we’re about half way Read moreVMware Monitoring in SQL Monitor
Jon Hayman reviews how the metrics available in SQL Monitor can help you diagnose problems that might come from SQL Server running in a virtual environment. Read moreHow to monitor backups and other SQL Agent jobs using SQL Monitor
How to monitor any SQL job that runs on the SQL Server Agent so that you're alerted quickly if SQL Agent goes offline, or if a job fails, or fails to start, or is running slow. Read moreRedgate Hub
-
Product Articles
Tips and how-to guides for Redgate products
-
University
Easy to follow video courses
-
Events
Join us online, or get sponsored
-
Forums
Ask, discuss, and solve questions about Redgate's tools
-
Community
Develop your skills and meet Redgate Advocates and Friends
-
Simple Talk
In-depth articles and opinion from Redgate's technical journal