Item: IDERA SQL Diagnostic Manager for SQL Server
Rating: 10
Author: José Javier Dominguez Reina

Use Cases and Deployment Scope

We are using the IDERA SQL Diagnostic Manager for SQL Server in the Production department of the organization to detect erroneous or very heavy queries to the database. We are using this product to identify that consulting slowed down the performance of applications in the organization, achieving optimal performance after correcting said queries.

Pros and Cons

Database query optimization.
Monitoring of databases in real time.
Performance analysis and trends in the database.

Detection of heavy database queries.
Monitoring of database configuration changes.
Obtaining data from multiple database servers simultaneously.

Return on Investment

Reduce development hours by locating the queries to be optimized.
Reduce hardware cost by requiring fewer hardware resources by optimizing database queries.
Provides a very complete scorecard.

Alternatives Considered

Redgate SQL Monitor and LogicMonitor

IDERA SQL Diagnostic Manager for SQL, Redgate SQL, and MonitorLogicMonitor are similar products to each other. We decided on IDERA SQL Diagnostic Manager for SQL because our experience with locating heavy queries has been very good and it provides real-time monitoring of all servers and databases. It also allows you to have a large volume of historical data which allows you to analyze trends in the databases.

Key Insights

Do you think IDERA SQL Diagnostic Manager for SQL Server delivers good value for the price?

Yes

Are you happy with IDERA SQL Diagnostic Manager for SQL Server's feature set?

Yes

Did IDERA SQL Diagnostic Manager for SQL Server live up to sales and marketing promises?

Yes

Did implementation of IDERA SQL Diagnostic Manager for SQL Server go as expected?

Yes

Would you buy IDERA SQL Diagnostic Manager for SQL Server again?

Yes

Other Software Used

Oracle SQL Developer, MariaDB MaxScale, SolarWinds Database Performance Analyzer

Likelihood to Recommend

IDERA SQL Diagnostic Manager for SQL Server generates very visual graphs of the databases and servers that allow you to create a command me chart in an easy way, it is also capable of identifying the queries that penalize the database the most to correct it. It is not necessary to install any component in the databases to be monitored. As against, the installation of IDERA Dashboard can be complicated and does not detect database clusters well.

IDERA SQL Diagnostic Manager for SQL Server Smart Dashboard

Overall Satisfaction with IDERA SQL Diagnostic Manager for SQL Server