IMPACT2021 | Life Cycle of a Query in SQL Server – Deepthi Goguri

IMPACT2021 | Detection of Performance Anomaly in Mobile Network Node Entities in Evolved Packet Core Network Using Deep Embedded Self Organizing Map (DESOM) – Jayanta Choudhury, Anila Joshi
February 1, 2021
IMPACT2021 | Technical methods to solve performance issues – Kevin Luey
February 1, 2021
IMPACT2021 | Detection of Performance Anomaly in Mobile Network Node Entities in Evolved Packet Core Network Using Deep Embedded Self Organizing Map (DESOM) – Jayanta Choudhury, Anila Joshi
February 1, 2021
IMPACT2021 | Technical methods to solve performance issues – Kevin Luey
February 1, 2021

IMPACT2021 | Life Cycle of a Query in SQL Server – Deepthi Goguri

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!

Speaker
Deepthi Goguri
SQL Database Administrator, Intone Networks Inc.

Track
Performance Engineering and DevOps

Speaker Interview Video:


IMPACT Session Video:

To view the video you must have a CMG membership. Sign up today!

For existing members sign in here.