SQL Monitor Reviews

I can see all my servers on a single window. I can see their health and instantly drill down for a more detailed look at what's going on.

Can be cumbersome to set up and configure, but overall worth the effort.

Get training on the product, and be ready to be amazed!

We know immediately if a server isn't performing optimally. And we can instantly see the data we need to address the issue.

Redgate's tools just work and SQL Monitor is no different. I have used a lot of tools but the redgate tools zero in on what you need to know and cut out the noise. It is very easy to diagnose your problems and get alerts before problems hit you out of the box.

Not much. Maybe pricing? The redgate stuff can tend to get expensive if you have a lot of instances. For example, we had one MASSIVE server that absolutely required a license. We also had 40 instances that needed very light monitoring - it was just too expensive to go with SQL Monitor for all those little instances.

Look at their entire suite of tools. Even the sql cloning stuff they have is a life send if you have a development shop that needs a lot of instances or data refreshes. They can even manipulate data and scramble data for test environments. Makes it really easy.

In a 24 hour organization - up time is a must. It gave us a fighting chance against all of those problems that just "come up". Poorly performing execution plans, drive size, paging issues, memory, hug threads, bad actor users... it does it all.

If you are not a full time Database Administrator but would like to be proactive in monitoring your SQL servers this is brilliant.

It only support Microsoft SQL servers which is not yet the only available solution out there.

Keep improving, maybe adding support for other non-Microsoft products is worth it as well? .

Helps us being a proactive support team.

I like that it is a very comprehensive monitoring tool. It shows an SQL admin all that is needed to successfully monitor the health and performance of an installed SQL Server

I found that there is a significant learning curve to overcome to fully utilize the benefits of SQL Monitor.

Prior to using SQL Monitor, my company experienced numerous issues with our SQL server. File locks, space allocation, CPU usage were just a few of the issues discovered and resolved with the use of SQL Monitor.

The software is open source and free for the people who wants to learn SQL and would like to join the SQL related professions. It is easily integrated with visual studio.

The database and scripts need to be run according to the windows version, which is 64 or 32 bit. We need to open the SSMS to import the database if the size of the file is huge. It is a little annoying.

It is a management tool for different Databases and has global usability. The deploy function of Redgate is quite advanced and user friendly and helps to deploy the functionalities for multiple databases.

Simple interface, easy to customize. Color coding is pleasant. Frequent updates

Drilling down can sometimes take weird steps.

Monitoring SQL Server for blocks and unauthorized access. Displays restarts and long queries, Job deviations. I like how it groups similar errors together to simplify review. You can also segment servers into groups like Production UAT and DEV. Support is excellent too. Quick to respond, and knowledgebase is excellent for self serve support as well. I find Red-Gate to be an excellent company, supporting the Database users community extensively.

SQL Monitor effectively helps me overcome various bottlenecks of my SQL servers and ensures performance utilization with high efficiency. It provides high availability and failover notifications for both our active and passive nodes in our cluster. Capacity planning is also great for managing our memory and buffer allocation with SQL Monitor.

More workload is imposed in our SQL server as SQL monitor operates 24/7 for monitoring server activities. In order to improve this workload, we can opt for database clusters with a large number of worker nodes to optimize capacity management.

SQL Monitor effectively monitors our Amazon RDS clusters. It provides detailed performance metrics and notification alerts. As its centralized monitoring tool, there isn't any location or platform dependencies involved. Troubleshooting is great as I am able to group our RDS performance metrics & I can customize our instance alerts based on client priotity standards. API integration is seamless between Amazon Relational Database Service and SQL Monitor which is a big positive aspect for our continuous monitoring requirements.

It proactively gathers metrics, so you have the data you need to troubleshoot even if you didn't know in advance that you would need to collect some specific metric. The analysis and alerting tools are rich and easy to use.

If you have servers in an AlwaysOn Availability Group, it wants to connect to all of them as well as the load balancer. If your load balancer isn't configured to pass WMI as well as SQL traffic, SQL Monitor will fail to install. That can be a problem if you don't have permission to change the load balancer configuration.

Proactive monitoring of SQL servers in production environments. Rich data for troubleshooting problems.

1) Multiple SQL server can be monitored simultaneously.

2) Real time graph helps to analyse the health of SQL server.

3) SQL monitor reports can be reviewed in different perspective.

4) User can get alert for any discrepancy or error without having to review graph continuously.

1) it do not provide any fix or suggestions to fix performance issues.

2) The constant monitoring of SQL server present load on sql server.

3) there are not enough templates to monitor server.

4) monitor reports are not customisable to be sent to DBA or SQL Developer

It is a great tool to monitor SQL server health.

1) We are getting auto notification for health check on sql server.

2) It provides monitor reports. These reports are easy way to find issues in the system.

3) it helps to have effective resource management by reviewing the utilisation of resources.

The program sets up easily, makes connections to all of your servers intuitively.

During monitoring, the hit on server performance was greater than I believe it should have been; the level of statistics gathered was good, but not enough to warrant the incursion on performance.

Monitoring several medium-sized databases on two servers. Gave some insights into how server resources were being used.