SQL Monitor is a SQL Server monitoring tool that helps teams looking after SQL Server be more proactive. Not only does SQL Monitor alert you to current issues, it gives you the information you need to stop them happening in the future.What's new in version 7
With SQL Monitor in place you can spot trends and issues occurring and take action before it becomes a problem for your users. So whether you need to work out how long it's going to be until that disk is full, or be alerted when unusual activity starts to impact database performance, SQL Monitor gives you the information and insight you need, tailored to your SQL Server environment.
It comes with preconfigured and customizable alerts to show you priority issues as well as baseline/trend analysis and integrated reporting capabilities.
If you’re doing SQL Server monitoring with custom scripts, you know how long it takes. For a growing environment, it can take hours. SQL Monitor cuts your daily check to minutes with a web-based overview of all your SQL Servers that updates every 15 seconds.
It’s simple to track the load on your system right down to the database level. You won’t miss a thing, no matter how big your environment gets. And you’ll never have to fix a broken reporting script again.
You know the type of question - “Why was the database so slow half an hour ago?” SQL Monitor gives you the answer and makes it simple to show the problem to other people.
Whether you need to talk to your boss about capacity planning, management about slow performance, or developers about troublesome queries, SQL Monitor makes the conversation easy and helps you keep on top of your SQL performance monitoring.
“It’s a tool you just can’t live without. It delivers an incredible amount of useful data in an easy to use format.”
“Knowing what is going on, and being armed with enough information to act is a huge time saver. This product has changed how I monitor my systems.”
“It is easy to use, has the data we need, and more importantly everyone just gets it. It's the freaking iPhone of SQL monitoring - my boss can get it, the junior people can get it, the senior people...everyone just gets it. To me, that has tremendous value.”
|Deployments – Unearth bad database deployments|
If you’re deploying your database changes using one of Redgate’s deployment tools (DLM Automation, ReadyRoll or SQL Compare) you can see the impact of that deployment directly within SQL Monitor.
Every time you make a deployment, SQL Monitor picks up this information and displays it on the Instance timeline next to key SQL Server metrics. So if you suddenly see unusual behavior after a deployment, you’ll know exactly where to start your investigations.
|Reporting - Generate reports about your servers and company health|
The new Reporting module allows you to create customized reports.
These combine the performance metrics available in SQL Monitor’s analysis view with summary information on things like server uptime, the numbers of alerts being raised, or the disks which are filling up fastest.
Reports can be exported to PDF and emailed to you on a scheduled basis.
|Alerting - Find problems before they become problems|
SQL Monitor comes preconfigured with 40 fully-customizable alerts for the most important operational and performance issues.
Covering query performance, database and job health, SQL Server issues, and machine-level concerns, SQL Monitor helps you find out about problems before your users do.
|Global Overview - See all your servers at a glance|
View all your SQL Server instances, availability groups, clusters, and virtual machines on one central web-based interface.
Check in with all your servers without remoting in - in seconds, not hours. If one bubbles up in need of attention, drill down for detailed performance statistics.
|Diagnosis - Uncover root causes in 5 minutes or less|
When performance problems occur, time is at a premium. SQL Monitor gives you a focused set of performance metrics that quickly help you pinpoint the cause of any performance issue.
Correlate metrics and compare them to their baseline activity to find the root cause, not just the symptoms in 5 minutes or less.
|Top Queries - See which queries are slowing you down and how to fix them|
Which queries have the biggest impact on your system?
SQL Monitor gives you the answer.
For every query, it shows you performance details, delays caused by resource waits, the T-SQL text, and the query plan. With this data at your fingertips, it’s quick to find and fix deadlocks and long-running or expensive queries.
|Availability Groups - Get insights into the performance and status of your groups|
SQL Monitor has Availability Group-specific overviews, alerts, metrics, and wait types.The Availability Group overview shows at a glance the status and performance of an Availability Group and allows you to drill down into the replicas and databases.
With 17 Availability Group-specific metrics and six alert types, it gives you a complete picture of your databases so you can use your Availability Groups with confidence.
From safely making a change in development through to monitoring its impact in production, Redgate is with you every step of the way. We give you the tools and insight you need to optimize your development processes.More about the tools
Redgate’s Database DevOps solution lets you extend your DevOps practices to SQL Server databases so that you can optimize productivity, agility and performance across the full database lifecycle and become a truly high performing IT organization.Learn about the benefits