SQL Server wants memory the way a runner wants food after a marathon: it wants it all and it wants it right now. You can configure max memory settings, but will that cover all of SQL Server’s uses for memory? Jes Schultz Borland will uncover the truth about how SQL Server is handling memory in this free 30 minute video. Single page and multi page allocations will be discussed, along with changes in SQL Server 2012. This talk is designed for DBAs with a couple years of experience poking under the hood who are interested in learning more about how SQL uses memory.
Download Scripts from the Webcast for SQL Server Memory Analysis
You can download the .sql scripts used here!
Links from Webcast Q&A
Some great questions were raised during the webcast! To learn more about Lock Pages in Memory, read Brent’s blog, Consulting Lines: SQL Server Needs a Dog. If you’re curious about where to start with your maximum and minimum memory settings, check out our SQL Server Setup Checklist!