SQL Server Administration & Maintenance

SQT07 Inside the Memory of SQL

11/16/2021

2:45pm - 4:00pm

Level: Advanced

Bob Ward

Principal Architect, Microsoft Azure Data

Microsoft

In this session, I'll describe how SQL Server memory management works including architecture, limits, and how you can configure and monitor memory usage. I'll also describe differences in memory management for SQL Server on Linux and Azure SQL.

You will learn:

  • How memory management works within SQL Server and Azure SQL
  • How internals of SQL memory can help you effectively managed and maintain SQL Server
  • New advanced skills, tips, and tools to dive into the memory internals of SQL Server