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.
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.
Justin is a Principal Consultant for Coeo, a Microsoft Gold Partner providing SQL Server consulting services for upgrade, performance tuning, scalability and availability solutions for SQL Server. Coeo also offer Remote DBA services for mission critical SQL Server platforms. Justin is an MVP and co-authored Wrox IT Pro: SQL Server 2012 Internals and Troubleshooting, as well as the same title for SQL Server 2008 and SQL Server 2005 Performance Tuning.