Item: Redgate Monitor
Rating: 10
Author: Verified User

Overall Satisfaction with Redgate SQL Monitor

Use Cases and Deployment Scope

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.

Pros and Cons

Pros

Missing index
RAM usage
CPU usage

Cons

Provide a dedicated section of code for missing index
Automation layer

Return on Investment

Licensing cost is per license...
A pre-formatted analysis graph would be great

Alternatives Considered

System Center Operations Manager and Dynatrace

Redgate SQL Monitor beats them so far since it can access SQL server kernel and internals.

Support Rating

Fast support responses from Redgate

Key Insights

Do you think Redgate Monitor delivers good value for the price?

Yes

Are you happy with Redgate Monitor's feature set?

Yes

Did Redgate Monitor live up to sales and marketing promises?

Yes

Did implementation of Redgate Monitor go as expected?

Yes

Would you buy Redgate Monitor again?

Yes

Other Software Used

Dynatrace, System Center Operations Manager

Likelihood to Recommend

An appropriate scenario for Redgate SQL Monitor would be, collecting internal execution metrics of production and mission-critical SQL server. So from a technical release perspective, we can use it as a baseline.

If I could suggest an optimization it would be to be able to insert events (feedback loop) of monitored SQL server major and minor changes (OS, SQL, or others).

Redgate SQL Monitor Review