White Papers

Deploying Microsoft SQL Server 2008 based Decision Support Systems using Dell EqualLogic 10GbE iSCSI Storage 17
be chosen for I/O (instead of the “Round Robin” approach, which would choose the next path in the
sequence regardless of queue depth).
4.5 Microsoft SQL Server 2008
You should consider the following best practice guidelines for configuring SQL Server®.
4.5.1 ProperlySizetheStorageVolumesforEachDatabaseI/OComponent.
SQL Server® data layout on storage volumes is an important factor for optimal operation of DSS
workloads. Storage volumes need to be appropriately sized for capacity and performance to host the
database data, transaction logs and ‘tempdb’ databases. In the test configurations discussed in this
paper, we created five volumes for hosting the database data. We created two additional volumes for
hosting the ‘tempdb’ database and for the transaction logs. The data and ‘tempdb’ volumes were
hosted in one storage pool. The log volumes were hosted in a separate storage pool.
DSS workloads often create large temporary data objects during query processing (see Section4.1.3,
Storage Pool Configuration). Therefore, it is critical to size the ‘tempdb’ appropriately. An improperly
sized tempdb can significantly impact performance.
Figure7:MPIOSettings