Filter Ratings and Reviews
Filter 24 vetted Redgate SQL Monitor reviews and ratings
Reviews (1-5 of 5)
February 28, 2020
Redgate SQL Monitor Review
We are using Redgate SQL Monitor to raise performance issues of stored procedures and resource pressures. It identifies the under-performing stored procedures and from that we can leverage any missing index or SQL performance information caught by SQL server.
- Missing index
- RAM usage
- CPU usage
- Provide a dedicated section of code for missing index
- Automation layer
February 25, 2019
Monitor your SQL server made easy
We have implemented Redgate SQL Monitor to proactively monitor one of customer's SQL servers used by their CRM software. It helped us find the main cause of their CRM software's bad performance following a P2V migration and change in the number of virtual CPUs. We have used it since for alerting and reporting.
- It is easy to use and provides very good reporting on the SQL servers being monitored. These reports are used in our monthly customer reports.
- Redgate does a very good job at improving the product, fixing bugs and adding new features compared to other products I have researched.
- The insights provided makes it an ideal tool for database administrators and software developers.
- It is a great tool for helping DBAs with their work but a bit expensive for MSPs to use for their day to day monitoring.
February 13, 2018
Redgate SQL Monitor vs Solarwinds
I used to use SQL Monitor because I could not afford AppInsight for SQL from Solarwinds.
However they offer different benefits. A feature that Redgate offers is an indication if your server is under attack and where from, a simple extension would allow further action to be drawn from this, eg looking up the IP in a an IP Black list, which could advise you to block further access from that IP address in China. Redgate reports it as a fault, not an attack; they don't look at the bigger picture.
This is the fundamental flaw with all Redgate products, they are too precious about their intellectual property to the detriment of usability. This is often found with installation and upgrades failing, hence they have written but not publicised sanitization tools to remove all traces of Redgate from your system, so once it is installed don't touch it, and I am a fan of Redgate toolbelt. If they had only offered a scripting/WebHook interface to SQL Monitor then an eco system could emerge around it for the benefit of all. Redgate products typically have a UI which is a hosted Chromium UI, so the UI is actually a web page, which has some advantages, speed not being one of them.
So should you get SQL Monitor - well yes (unless you have Solarwinds and thus AppInsight for SQL)
However they offer different benefits. A feature that Redgate offers is an indication if your server is under attack and where from, a simple extension would allow further action to be drawn from this, eg looking up the IP in a an IP Black list, which could advise you to block further access from that IP address in China. Redgate reports it as a fault, not an attack; they don't look at the bigger picture.
This is the fundamental flaw with all Redgate products, they are too precious about their intellectual property to the detriment of usability. This is often found with installation and upgrades failing, hence they have written but not publicised sanitization tools to remove all traces of Redgate from your system, so once it is installed don't touch it, and I am a fan of Redgate toolbelt. If they had only offered a scripting/WebHook interface to SQL Monitor then an eco system could emerge around it for the benefit of all. Redgate products typically have a UI which is a hosted Chromium UI, so the UI is actually a web page, which has some advantages, speed not being one of them.
So should you get SQL Monitor - well yes (unless you have Solarwinds and thus AppInsight for SQL)
- It will tell you if your server is under attack.
- You can quickly see how your server is performing and which queries are taking the longest
- I gives you the feeling that you are in control of your database, that you know what is going on for when they users ring up and tell you that the server is slow
- Openness - They are too attached to their Intellectual Property to the detriment of usability, stability and reliability. So once its is installed and working leave it alone. Best run it on a VM as that can be restored quickly for when it breaks.
- If they exposed an API/SDK that allowed you to leaver their products life would be far sweeter, it would feel less of a battle.
- Add WebHooks to SQL Monitor to enhance integration to other subsystems.
- Make it easy to install in default mode. So you are not forced to use TomCat Use as ASP.Core Selfl Hosting options.
It is used in a client site to monitor their SQL estate.
- Global Dashboard gives a great overview
- Ability to rename/alias a server
- Easy to navigate
- I don't think the custom metrics/alerting is as flexible as say SQLSentry
August 05, 2016
SQL Monitor - Automating your morning checks
We use Redgate SQL Monitor as our primary SQL Server monitoring application. It's main tasks are to alert the DBAs of any problems with SQL server, such as failed jobs, long running queries, SQL errors, or host-level issues like high CPU or filled disks. We also use it for aggregating performance metrics and troubleshooting performance issues using wait statistics
- Provides a quick dashboard to identify what servers have issues, and the priority of them
- Allows for granular control over thresholds and alerting which can be set at multiple levels
- Let you easily go back in time to see what was going on in the past
- Incremental releases can be buggy
- Isn't the best for pinpointing performance issues
- Web interface can be sluggish
Redgate SQL Monitor Scorecard Summary
Feature Scorecard Summary
About Redgate SQL Monitor
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.
SQL Monitor grows with your estate through distributed monitoring, allowing you to monitor tens or hundreds of servers from a single user interface. As well as monitoring on-premises servers, you can also monitor servers on VMs, AzureDB and AWS.
Redgate SQL Monitor Screenshots
Redgate SQL Monitor Integrations
Redgate SQL Compare, Redgate SQL Code Guard, Redgate SQL SQL Change Automation
Redgate SQL Monitor Competitors
SolarWinds Database Performance Analyzer, IDERA SQL Diagnostic Manager, SentryOne SQL Sentry, Quest Spotlight
Pricing
- Has featureFree Trial Available?Yes
- Does not have featureFree or Freemium Version Available?No
- Has featurePremium Consulting/Integration Services Available?Yes
- Entry-level set up fee?No
All prices are per server and include one year’s support and upgrades. For clusters, each node requires a license. Virtual machines also require a license. You don't need to buy extra licenses for multiple SQL Server instances on a server.
Redgate SQL Monitor Support Options
| Free Version | Paid Version | |
|---|---|---|
| Phone | ||
| Forum/Community | ||
| FAQ/Knowledgebase | ||
| Social Media | ||
| Video Tutorials / Webinar |
Redgate SQL Monitor Technical Details
| Deployment Types: | On-premise |
|---|---|
| Operating Systems: | Windows |
| Mobile Application: | No |
| Supported Languages: | English |