A Practical Deep Dive into I/O for T-SQL Performance Tuners

Andy Yun

You’re a T-SQL performance tuner and know that I/O is a critical factor in overall query performance. But you’re also not intimately familiar with the lifecycle of I/O in SQL Server, particularly on the hardware layer. Maybe you’ve struggled trying to determine if an I/O bottleneck originates in the code or within the hardware stack?

Join me for an in-depth, advanced but essential “what you need to know” exploration of SQL Server I/O. We will demystify the relationship and lifecycle of I/O starting from an execution plan operator, to the storage engine, through your physical server, and out to your underlying storage subsystem. Then we will the apply this knowledge to example use cases.

When you leave, your new knowledge will help you properly triage the origins and root cause of your I/O related performance issues.