Many 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, how SQL optimizer chooses the execution plan when you submit any query. This session will contain demos showing what happens at each component when you submit a query. Deepthi will show you how the SQL engine thinks – enabling you to think like it!
SQL Database Administrator, Intone Networks Inc.
Performance Engineering and DevOps