SQL Server Memory Internals & Troubleshooting

Target Audience:

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


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 Want to Present 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.

Additional Resources:

The following two tabs change content below.

Amit Bansal

Latest posts by Amit Bansal (see all)

Previous Post
How to write a kick a** anything.
Next Post
Inside Kubernetes – An Architectural Deep Dive

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.