Case Study: Ancoris achieves faster SQL Server monitoring and recovery with Idera SQL diagnostic manager

Extend SQL Server monitoring with Microsoft Operations Manager 2005™ using Idera SQL diagnostic manager

Ancoris, a specialist integrator of systems and security management solutions, needed better visibility and faster response for SQL Server production issues. Using Microsoft Operations Manager 2005 alongside Idera SQL diagnostic manager (SQLdm), Ancoris aimed to improve monitoring, diagnostics, and recovery across its customer environments.

Idera and Ancoris integrated MOM 2005 with SQLdm to provide automated alerting, detailed SQL Server diagnostics, and recovery actions. The combined solution helped shorten time to resolution by quickly identifying problems, notifying experts, and enabling targeted fixes; in example scenarios, it supported rapid identification of runaway processes, failed jobs, and slow queries, helping restore performance from 20+ seconds to under a second in one case.

Ancoris