Statistics and Memory Grant Feedback in SQL Server

Abstract:
Are you new to performance tuning and confounded by statistics? Do you wonder where these statistics come from, and how the optimizer gets the estimates from statistics? Do you know how the new feature memory Grant feedback works in allocating needed query memory to your queries?
Join us as we dive deep into cardinality estimation, how SQL Server uses statistics to build execution plans, where to find information about how statistics got used, why managing statistics is vital to performance and how memory grant feedback works.
This session will have awesome demos showcasing practical examples of how the optimizer uses statistical information for all those crazy queries you write.

Biodata: Deepthi Goguri is a SQL Server Database Administrator with 7 years of experience in Administering SQL Servers. She is a Microsoft certified trainer and Microsoft certified professional with an Associate and Expert level Certification on Data Management and Analytics. Deepthi blogs for DBANuggets.com