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

On-demand Webcast Abstract

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 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.

Presenter

Andy Yun is a Field Solutions Architect at Everpure, who has been working with SQL Server for over 20 years as both a Database Developer and Administrator. He focuses on performance tuning, with expertise in T-SQL, storage engine internals, and monitoring. Andy strongly believes in passing knowledge onto others, regularly speaking at conferences and user groups, and mentoring industry colleagues. Andy is a former Microsoft MVP, co-founder of the Chicago SQL Association, former co-leader of the Chicago Suburban User Group and Chicago SQL Saturday Organizing Committee.

Sponsored By