A mid-market SME customer in the province of Monza, PowerEdge R740 server running SQL Server Standard, a 1.2 TB production ERP database, steady transactional traffic. PERC H730 controller with 1 GB of write-back cache, eight 1.8 TB SAS 10K drives in RAID 10. Write latency spiked during batch windows (daily closes, month-end invoicing): from 5 ms at idle to 60-90 ms during batches.
Diagnosis: controller cache saturated on writes. The physical storage (SAS 10K) can do better if the controller stops choking it. The fix: upgrade to a PERC H755 with 8 GB of cache, keeping the same drives and the same RAID 10. Identical LSI-based family compatibility: direct foreign config import.
Execution: full SQL database backup (full + log) before the job. Three-hour overnight window. Server shutdown, controller replacement, PERC firmware update, boot, foreign config import (5 minutes), system startup, SQL integrity check (DBCC CHECKDB), synthetic batch test, back into production.
Result: batch latency under 15 ms, sequential write throughput +120%. No data loss. The customer carries on running the same drives.
# Pre · PERC H730 (1 GB cache)
4K random read 18,500 IOPS · 5.3 ms avg
4K random write 12,200 IOPS · 8.1 ms avg
1M seq read 820 MB/s
1M seq write 420 MB/s
Batch latency 60-90 ms (closes)
# Post · PERC H755 (8 GB cache)
4K random read 42,000 IOPS · 2.3 ms
4K random write 31,000 IOPS · 3.0 ms
1M seq read 1,250 MB/s
1M seq write 940 MB/s (+120%)
Batch latency 8-14 ms (closes)