Session Title: Demystifying SQL Server I/O To Improve Your T-SQL Performance
Speaker: Andy Yun
Abstract: Do you understand how SQL Server handles I/O? If not, you should. Understanding I/O is more important than ever with increasing cloud adoption, due to cloud costing models. But even on-premises, I/O has a direct impact on T-SQL performance.
Join me for a deep dive into the storage engine to understand how SQL Server handles I/O Concepts will be paired with T-SQL examples to illustrate the practical impacts.
When you leave, you’ll be able to optimize your T-SQL reduce I/O and improve performance across the board.
#sqlserver, #tsql, #storageengine
300+ sessions are now available on-demand from Data Platform Summit 2021 & 2020 at no cost. Browse all sessions.
Stay tuned, more learning coming your way.