Faster Microsoft SQL Server Performance with IBM FlashSystem Storage
Megan_Gilge 06000101S8 Visits (3376)
If latency, or I/O wait time, is limiting the speed of your database, consider upgrading your storage. Faster processors and increased bandwidth might be wasted if applications still wait on storage. Storage efficiency is often measured in input/output operations per second (IOPS), which is a measure of work versus time. However, low latency is key to increased SQL Server performance. While many traditional storage solutions take several milliseconds to access data, FlashSystem products use IBM MicroLatency to access storage in a matter of microseconds.
Flash System products provide solid-state storage with a hardware-only datapath that can be integrated into your existing environment. The small, 1U form factor enables as much as a petabyte of storage to be placed in a single rack, on a single floor tile. You can improve the performance of your entire storage environment by moving your most I/O intensive applications to FlashSystem storage while minimizing server licensing and administration costs.
For Microsoft SQL Server environments, you can achieve maximum performance by moving the entire database to FlashSystem storage. The greatest benefits can be achieved for databases with:
For other databases, consider moving the following components to FlashSystem storage:
Read the Fast