The Underground Map of SQL Monitor
The "metro map" of SQL Monitor, with sightseeing tips and essential stops along every line....
Original concept and design: Phil Factor.
Download the Map as a PDF wallchart: UndergroundMapOfSQLMonitor
Download the Map in SVG format: UndergroundMapOfSQLMonitorSVG
Highlights of Monitor Town
Sightseeing tips and essential stops along every line….
The Configuration “line” of SQL Monitor is where you go to manage monitored servers and SQL monitor users, to configure, customize and automate your monitoring and alerting strategy, for each server, manage your licenses, investigate errors and more.
Download the Configuration Map as a PDF: MonitorConfiguration
Time spent exploring the Estate line will help DBAs to monitor and safeguard the security, stability and availability of all servers in their care.
Download the Estate Map as a PDF: Estate
Stop off at Reports to create, configure and schedule reports to share with others in your organization.
Download the Reports Map as a PDF: Reports
Any metric sparkline in SQL Monitor provides a connection over to the Analysis page, where you can plot graphs showing the behavior of a group of metrics, around the time of slow performance, or a specific problem. This will help you expose the root cause of common bottlenecks, spot worrying trends, or patterns of failure around certain times.
Download the Analysis Map as a PDF: Analysis
Teams will visit the Alerts Inbox most days, in order to investigate and resolve problems that arise on any SQL Server. These might include: resource bottlenecks (CPU, memory or I/O issues); disk space warnings; failed backups and other scheduled jobs; slow performance, such as caused by ‘blocking’ or other other query problems; specific SQL Server errors, such as deadlocks. The Alert Details provide specialist diagnostics for each alert type and the Performance data for each alert tell you what was happening on the server and instance during and around the time the alert was raised.
Download the Alerts Map as a PDF: Alerts
The Overviews line is to SQL Monitor what the Central line is to London or the A-train to New York City. It is where you can review any problems that arise, directly within the context of server activity over that period.
The Metrics branch of the Overview line…
The processes and databases branches of Overviews…
Download the Overviews Map as a PDF: Overviews
Tools in this post
Redgate Monitor
Real-time SQL Server and PostgreSQL performance monitoring, with alerts and diagnostics
You may also like
-
Article
Picking over the Bones of a SQL Injection Attack
The best way to learn how to protect your databases from SQL Injection is to to see it in action and confront its consequences. This article tells the story of an attack on a vulnerable SQL Server REST interface, explaining how the attack unfolds, the mistakes that made it possible, and SQL Monitor's role as the 'canary in the mine'.
-
Webinar
A practical guide to migrating monitoring solutions
Understanding the future direction in your business is key to ensuring your systems support this and investing in new solutions is key. However this involves understanding the needs of a successful migration. In this webinar Microsoft Data Platform MVPs Grant Fritchey and Anthony Nocentino will share practical experiences of migration and the considerations needed within organizations when introducing new tools.
-
Article
Migrating Between Monitoring Systems
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 process
-
Webinar
Key Signs Your Business Needs a Database Monitoring Tool
Join Redgate's database monitoring experts, Anderson Rangel and Steve Jones, as they discuss the telltale signs indicating the need for a dedicated database monitoring solution.
-
Forums
Redgate Monitor Forum
Real-time performance monitoring for SQL Server and PostgreSQL, with alerts and diagnostics
