Case Study: University of California, Irvine improves SQL Server performance with Idera SQL Doctor

University of California at Irvine - Customer Case Study

The University of California, Irvine, an educational institution in the USA, was struggling with SQL Server performance issues caused by index and query problems, along with disk, memory, network, processor, and database setting issues. The team needed a way to quickly identify and fix problems without risking further impact to database performance, and they evaluated Idera’s SQL Doctor for that purpose.

Idera implemented SQL Doctor to run health checkups, provide prioritized optimization recommendations, and generate scripts to tune or undo changes. As a result, the university improved database visibility, resolved issues proactively, and boosted performance and resource use; measurable reductions included 60% to 80% fewer backup and workload issues, and more than 80% fewer index, query, resource, and SQL Server settings issues.

University of California at Irvine

Thomas Robbins

Database Administrator