Posts Tagged with SQL Monitor
Redgate announced today a new SQL Monitor feature to ease the problems DBAs and developers face with query tuning and optimization. Its advanced query tuning and tracking capability will now enable DBAs and developers to identify costly queries, get recommendations on how to optimize them, and track them to compare their performance over time. Read more
I’ve written before about building your own monitoring systems versus buying a monitoring tool like Redgate SQL Monitor. There I talked about the time that someone tasked with managing and maintaining data gets back in their day when they purchase a monitoring solution. However, that’s not where the business focuses. The business frequently wants... Read more
In the IT team at Redox, I wear two hats: Software Development Manager and DBA. I’m the only DBA in the team, so if anything goes wrong it’s my job to identify and fix it. As you might imagine, this can be challenging when being a DBA isn’t your full-time role. Based in Sydney,... Read more
This question comes up all the time: How do you migrate between monitoring systems? The answer is both simple and complicated. In order to understand this better, rather than just rely on my own knowledge, I reached out to a number of people to see how they accomplished this. I’m going to summarize their... Read more
This year we’ve been expanding SQL Monitor’s capabilities around the theme of Estate Management and we’ve just released a new capability – the discovery of on-premises SQL Servers and instances. We started on this journey with basic instance configuration observability and alerting earlier this year. While gathering feedback and finding ways to improve our... Read more
To help organizations explore and manage the advantages the cloud provides, the latest release of SQL Monitor now supports Amazon EC2 and RDS, and Azure SQL Database and Managed Instances alongside on-premises SQL Server. A new global dashboard also allows users to check the health of their entire SQL Server estate at a glance.... Read more
When it comes to reputational risk, a reactive approach is generally taken by organizations, with efforts focused on handling threats to their business they are already aware of. As much as this enables short term damage limitation, it may not be enough to manage and protect your risk in the long term. Instead, a... Read more
More and more organizations are managing some part of their data in the cloud. Gartner and similar organizations are showing massive growth in cloud adoption in 2020. Redgate’s own State of Database Monitoring survey shows cloud adoption rising rapidly. Everyone, it seems, is moving to the cloud. Yet, there is data out there that’s... Read more
I have written a nearly 1,000 page book on SQL Server performance tuning. In several chapters through the book, I outline all the necessary metrics you need to monitor your systems. I also show exactly how to put together those metrics in a variety of tools built into your OS and SQL Server itself.... Read more
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 customer impact, whether employees... Read more