IDERA SQL Diagnostic Manager for SQL Server fits the bill
Rating: 9 out of 10
IncentivizedUse Cases and Deployment Scope
We rely on IDERA SQL Diagnostic Manager for SQL Server to monitor all of our production SQL server environment. This includes our standalone instances as well as our always-on-availability groups. IDERA SQL Diagnostic Manager for SQL Server has allowed us to automate all of our monitoring as well as giving us a bonus of the predictive functionality to find issues before they cause problems.
Pros
- Ease of setup--agentless
- Flexible in terms of configuring alerts and thresholds
- Cost effective
Cons
- Windows client has some issues. When you have small time intervals for your data collection, it can cause the client to become unresponsive and require you to restart it.
- It takes more time to get the web client running than it does to get the windows client running.
- The visualizations have been the same for the last eight years--could use a little bit of a refresh.
Likelihood to Recommend
IDERA SQL Diagnostic Manager for SQL Server is well suited for monitoring your SQL server instances, either standalone, clustered or always-on-availability groups. I believe the best scenario is on production servers. For development instances, perhaps it is not as cost effective. There may be more cost-effective solutions in those types of scenarios.