TrustRadius
https://media.trustradius.com/product-logos/vz/gZ/HIS3L58LUCQW.PNGRedgateMonitor your SQL server made easy2019-02-25T18:15:54.366ZWe 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.,8,Redgate SQL Monitor is an expensive tool and unless it is the customer's wish to implement it, I would probably use other free tools available.
We have implemented it for one of our customers who was happy to pay for the license.,SolarWinds Database Performance Analyzer and SpiceworksVerified UserRedgate SQL Monitor vs Solarwinds2018-02-13T19:42:16.470ZI 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),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.,8,The quality of the product and give a negative investment impression, on the plus side when it does work it is a god send.
Day to day tasks as made simpler, and a feeling of security of realised. Just don't change anything.,,Microsoft Visual Studio Team System, TelerikDoug ThompsonRedgate SQL Monitor2016-05-26T20:09:08.520ZIt 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,8,Clients can review all their estate in one place, far easier and better than what SCOM was providing them with,SQL Sentry Performance Advisor and Dell Spotlight,Solarwinds Database Performance Analyzer for SQL Server, SQL Sentry,Dashboard
Popups when hovering a mouse over a server on the dashboard is a nice touch,I wish it had the highlight a time period and right click for top SQL feature which you get in SQL Sentry,7Chris TaylorSQL Monitor - Automating your morning checks2016-08-05T20:14:28.657ZWe 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,9,Allows us to proactively fix issues before they happen
Allows us to quickly react to issues without having to wait for someone else to notice
Cuts down on the amount of time spent doing daily checksVerified User
Windows
Redgate SQL Monitor
22 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
