EMC Symmetrix DMX-4 Enterprise Flash Drives With Microsoft SQL Server Databases

Free registration required

Executive Summary

This white paper examines deployments of SQL Server 2008 using enterprise Flash drives. It shows that Flash drives deliver vastly increased performance to the database application when compared to traditional Fibre Channel drives, both in transaction rates per minute as well as transaction response time. In the tested configuration, each Symmetrix DIvIX-4 EFD device provided a 110 rate of 2.900 TOPS with an average response time of less than 5 ms. testing for the EFD configuration was limited by CPU utilization. In contrast, the HD]) configuration provided 250 IOPS at a latency of 17 INS. This represents a 10 improvement of 1.140%, based on a comparison of four enterprise Flash drives to 34 traditional Fibre Channel drives.

  • Format: PDF
  • Size: 518 KB