Session: Life Cycle of a Query in SQL Server
Many DBAs and Developers work with SQL Server but don’t fully understand how it really works behind the scenes. Join Deepthi on her dive into the internals of SQL Server to explain why knowing what goes on under the covers will help you make better decisions quickly when solving performance problems in SQL Server. This session will cover ACID properties, key components of the Relational Engine, Storage engine, Cache and the Transaction manager. We will also cover what happens under the covers during read and write operations within SQL Server.
Deepthi will show you how the SQL engine thinks – enabling you to think like it!
Bio
I am a SQL Server Database Administrator with 7 years of experience in Administering SQL Servers. I am a Microsoft Certified Trainer (MCT), Microsoft Certified professional with an Associate and Expert level Certification on Data Management and Analytics. I am a Blogger for DBANuggets.com