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 more
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... Read more
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 more
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... Read more
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 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
How to use SQL Monitor to identify an unusual set of behaviors on the server, then narrow down the cause of the behaviors to a particular query. Within that query we have the starting point for tuning the query to get better performance. Read more
One of SQL Monitor’s most valuable capabilities is raising alerts when bad things happen in SQL Server. The alerts are listed within SQL Monitor but can also be sent out as emails. However, many of our customers have said they’d like to see those alerts in their other systems too. The latest version of... Read more
I’ve been lucky enough to spend some time as a racing driver, racing BMWs for three years before joining the BRSCC Porsche Championship. Steve McQueen famously said ‘Racing is life. Anything before or after is just waiting’. When I’m waiting, I’m a SQL Server DBA consultant and throughout my racing and DBA career, I’ve... Read more
