SQL Server Memory Internals & Troubleshooting by Amit Bansal

Target Audience:
The session is for SQL Server DBAs. Minimum 2 years of working experience with SQL Server.

Abstract:
Welcome to the dungeon. Yes, SQL Server memory concepts are like entering a dungeon where you are guaranteed to get lost. It’s dark and complex out there and not many have come back alive. Join Microsoft Certified Master of SQL Server, Amit Bansal, and find your way out from the dungeon. In this deep-dive session you will understand SQL Server memory architecture, how the database engine consumes memory and how to track memory usage. Complex concepts will be made simple and you will see some light beyond the darkness. This session will be an eye-opener for you. Assured.

Why I Presented This Session:
In my consulting engagements, I still see that customers have memory issues with SQL Server (even when they have highly configured servers). SQL Server Memory is convoluted and not well understood by many. I therefore designed this 60 minute session to cover the concepts quickly, followed by some deep dive demos on troubleshooting memory.