SQLBits 2010

Notes from the field: High Performance storage for SQL Server

This session provides an overview of a recent customer engagement to investigate storage performance problems and evaluate potential solutions. The session include details on measuring performance of the existing storage solution, profiling SQL Server disk IO activity and tools to simulate load and evaluate performance.

This session provides an overview of a recent customer engagement to investigate storage performance problems and evaluate potential solutions.  The session include details on measuring performance of the existing storage solution, profiling SQL Server disk IO activity and tools to simulate load and evaluate performance.

The session will discuss the benefits and drawbacks of traditional high performance SAN based solutions and compare these with SSD and ioMemory solutions.

The session includes a case information from a customer deployment where performance of existing shared SAN storage was evaluated and a high performance storage solution implemented.