SQL Monitor 9 – Proactively Monitor Large SQL Server Estates

Let me tell you about a real-world scenario that I often see at organizations I work with. In the perfect world, as organizations grow, their team should grow too. But often that isn’t the reality. The way it works out in most cases is, when organizations are small, the team put in place rock-solid plans to monitor their servers. However, when servers, data, and the business grows, the development and management team always gets busy with multiple tasks and eventually do not spend sufficient time building their monitoring solution. This leads to poor response time to business-critical issues with the system, resulting in sub-optimized servers.

Whenever I see such a scenario, I am always keen to introduce Redgate’s SQL Monitor. It is one of my favorite monitoring tools and it alerts you to problems before they occur, and automatically provides the data you need to monitor your server estate proactively. Recently, in version 9, I noticed it has a new addition in the form of the Estate pages.

The new Estate pages provide a very simple estate-wide view of important SQL Server metrics and tasks, such as disk space usage, backupsand other jobs, and information on recent updates and patches. They provide a central dashboard from which a team can review the overall health of their servers, spot any issues quickly, before they become real problems, and proactively assign priorities.

The Estate pages contain essential diagnostic data and provide information on installed versions, backups, disk space, and agent jobs, across every server and database on the monitored estate. The goal of the Estate page is to get a clear picture of the health and security of the database estate and provide a way to predict future behavior. It also helps to spot impending issues quickly and anticipate when resource constraints will escalate into the sort of problems that cause downtime, and unplanned maintenance work.

Here are few of the screenshot of the Estate Pages in the SQL Monitor 9.

SQL Monitor 9 - Proactively Monitor Large SQL Server Estates rg-q11

Installed Version

SQL Monitor 9 - Proactively Monitor Large SQL Server Estates rg-q12

Disk Usage

SQL Monitor 9 - Proactively Monitor Large SQL Server Estates rg-q13

Backup

SQL Monitor 9 - Proactively Monitor Large SQL Server Estates rg-q14

Agent Jobs

Alongside on-premises servers, it also manages Azure SQL Databases. I personally feel that Estate pages are going to change how I do SQL Server monitoring.

What Next –

Well, to learn more about SQL Monitor head here and read this article.

You can also download the SQL Monitor 9 Free Trial.

Reference: Pinal Dave (https://blog.sqlauthority.com)

,
Previous Post
SQL SERVER – Unable to Set Cloud Witness. Error: An Existing Connection Was Forcibly Closed by The Remote Host
Next Post
SQL SERVER – Stretch Database – ERROR: The Provided Location is Not Available for Resource Group

Related Posts

Leave a Reply

Menu