You may think of monitoring as helping you optimize your server performance and ensure availability, particularly in times of technical crisis. But did you know, monitoring helps your teams work together in times of human-based crisis as well. Organizations everywhere are taking action to ensure business continuity and to minimize…Read more
In 2018 we launched the industry’s first ever report into the state of SQL Server monitoring. The responses from over 600 SQL Server professionals gave us a unique insight into how they monitor their estates, the technologies they work with, and what were the biggest challenges they faced. In 2019…Read more
In 2018 we ran the industry’s first ever state of SQL Server monitoring survey. We received an excellent response from over 600 people in a range of sectors, in organizations of every size across the globe. They provided valuable insights into what they thought the biggest challenges were for them…Read more
If someone makes unauthorized changes to SQL Server configuration settings, it could compromise the availability, performance or security of your servers. Using using Extended Events, and a custom metric, in Redgate Monitor, Phil Factor offers a way to get an immediate notification of such changes, and investigate their cause.Read more
Today Microsoft released the public preview of Azure SQL Database Managed Instances – an exciting new option for running SQL Server workloads in the cloud. I’m pleased to say that initial support for this new offering is already available across the development tools in Redgate’s SQL Toolbelt, as well as…Read more
Jon Hayman shows you how to set up Redgate Monitor to monitor Azure-based clustered SQL Server instances right alongside your on-premise clusters. Read more
The Redgate 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…Read more
This quick tip illustrates Redgate 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 more
Jon Hayman reviews how the metrics available in Redgate Monitor can help you diagnose problems that might come from SQL Server running in a virtual environment.Read more
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 more