The Faster Microsoft SQL Server Performance with IBM FlashSystem Storage, TIPS 1038 IBM Redbooks Solution Guide describes techniques for improving SQL database performance by integrating FlashSystem storage into your environment.
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:
- High concurrent access
- Frequent random accesses to all tables
- Small- to medium-size databases
- Large, read-intensive databases
- Databases where fast performance is crucial for profitability
For other databases, consider moving the following components to FlashSystem storage:
- Transaction logs
- Temporary database (tempdb)
- Frequently accessed tables
Read the Faster Microsoft SQL Server Performance with IBM FlashSystem Storage, Tips 1038 solution guide to learn more about improving database performance with FlashSystem storage products.