Case Study: Medium Enterprise Wholesale Distribution Company achieves faster warehouse order processing with Idera Precise for SQL Server

Wholesale Distribution Enterprise Fixes Business-Critical Application Error

A Medium Enterprise Wholesale Distribution Company in the U.S. used JD Edwards ERP on Microsoft SQL Server to manage warehouse orders, but its business-critical Sales Order screen began freezing and causing missed same-day shipping SLAs. The company turned to Idera’s Precise for SQL Server to investigate the problem and identify why the application had become slow and unreliable.

Idera’s Precise pinpointed a problematic SQL statement whose execution plan was flipping between fast and slow versions. By locking in the faster plan, the company restored consistent performance, eliminated the apparent screen freezes, and helped warehouse staff meet their shipping deadline. The change also reduced repeated user resubmissions and improved the workload for the database team.