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
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
The lyrics from the electro duo Daft Punk (almost) succinctly sums up what SQL Monitor V6 is all about. We’ve looked at what you like and enhanced it. We’ve looked at what you don’t like and changed it. It’s now simpler and faster to diagnose SQL Server problems; the whole tool is just better.... Read more
The simple answer is yes, yes, and, um … yes! While on the surface it may look like nothing much has changed in v5.1 of SQL Monitor, in reality we’ve completely overhauled the core engine to make it more scalable, stable, and smarter. The latest version is the culmination of all the minor releases... Read more
I am eager to share with you some of the challenges my team faced in the last few months and how infographics helped us to solve them, optimize our internal communications, and ultimately increase our productivity. My name is Andrea Angella and I am a Software Engineer in the SQL Monitor team in Redgate Software. It’s... Read more
