Case Study: Large Enterprise Computer Product and Services Company achieves faster, reliable transactions with Idera Precise for SQL Server

Computer Product and Services Enterprise Fixes Critical, Failing Transactions

Large Enterprise Computer Product and Services Company, a U.S.-based enterprise, spent over a year building a new custom Microsoft .NET and SQL Server application but hit critical performance issues at rollout: transactions were failing or timing out, and the team initially blamed insufficient CPU capacity and virtual machines. Idera’s Precise for SQL Server was used to investigate the problem and determine whether the issue was in the database or the application code.

Idera’s Precise pinpointed the root cause in the application layer, showing that one method consumed most of the service time and CPU and that the bottleneck was demand, not server supply. After implementing the best developer-recommended change, average response time dropped from about 4 seconds to 0.5 seconds, failed transactions fell sharply, and throughput increased from roughly 6,000 to 12,000 executions per day, helping the company meet its go-live date.