october, 2022
tue18oct4:15 PM5:15 PMI will speak at SQLdaysMemory Grant in Microsoft SQL Server
Abstract
Abstract
When SQL Server executes a query, memory is required to store temporary data while rows are sorted or joined. This memory grant is controlled by the resource semaphore to avoid that a query monopolizes the whole memory for itself and thus all other queries must wait for their memory allocation. In this session, we will cover memory grant in detail and its server memory dependency, the impact of the resource governor, spilling to tempdb as a result of missing memory, and finally the functionality of the memory grant feedback feature, which was introduced in SQL Server 2019. Thereby, we will also learn how to identify and optimize memory intensive queries to increase overall throughput.
Time
(Tuesday) 4:15 PM - 5:15 PM
Venue
Erdinger Stadthallen GmbH
Alois-Schießl-Platz 1, 85435 Erding, Germany
Organizer
ppedv AG Campus Marktler Straße 15b, 84489 Burghausen, Germany
Speaker for this event
-
Torsten Strauß
Torsten Strauß
MVP | MCSE | MCT
Torsten (MVP, MCSE, MCT) has been working with Microsoft SQL Server since the turn of the millennium and is specialized in performance optimization for large SQL Server environments. He has been with bp as a database engineer for over two decades and collaborates closely with Sarpedon Quality Lab as a Principal Microsoft SQL Server Consultant. Torsten is the founder of inside-sqlserver.com and has given more than 120 presentations on Microsoft SQL Server performance optimization at national and international conferences and user groups. Torsten has been recognized as a Microsoft Most Valuable Professional for Data Platform since 2018.
MVP | MCSE | MCT