SQL Server 2012 Memory Management
SQL Server 2012 brings a wide range of changes, including a key change in how SQL Server memory is managed. Earlier releases of SQL Server have two memory managers, which have now been merged into one. And that’s just the beginning of the changes for SQL Server memory. This session will dive into SQL Server 2012’s new memory architecture. We’ll see how to diagnose memory performance issues and gain insight into memory pressure issues. We’ll also cover the settings to adjust memory configuration levels and their impact.
PASS Summit Seattle (Nov 2012)
This was my 2nd year @ the Summit as well as my 2nd time presenting a summit session, this time around it would be a regular 75 minute session on Memory Management with a special focus on the changes in how memory is managed with the SQL Server 2012 release
Video link http://www.sqlpass.org/SessionResources/Stream.aspx?sid=3158 & Download Material
PDF Presentation DBA-312 SQL Server 2012 Memory Management PDF
Aside from the Summit I have presented this Memory Management session @ these other events
- SQLRally Nordic 2012 Copenhagen (Oct 2012) http://www.server1002.dk/SQLRally/NeilHambly_SQLServer2012_MemoryManagement.pdf
- 24HOP SQL Server 2012 Virtual (Mar 2012)
- SQLCruise 2013 Miami (Jan 2013)
- SQLBits 11 Nottingham (May 2013) http://sqlbits.com/Sessions/Event11/SQL_Server_2012_Memory_Management
- SQLSaturday #211 Chicago (Apr 2013)
- SQLSaturday #229 Dublin (Jun 2013)
- SQLSaturday #238 Minnesota (Oct 2013)
- SQLSaturday #230 Rhineland (Jul 2013)
- SQLSaturday #275 Copenhagen (Mar 2014)
- Cambridge PASS Chapter Cambridge (Sep 2013)
- Leicester SQL UG Leicester (Jun 2013)
- Leeds SQL UG Leeds (Jul 2013)
- SQL Relay 2013R2 Norwich (Nov 2013)
I’ve was also able to present a special Deep-Dive 2-Hour version (Jan 2013) of this session at quite an unusual conference location, as this was aboard a Cruise ship Really! YES, Really! I’m talking of course about the acclaimed SQL Cruise experience http://sqlcruise.com/
It was my 2nd SQL Cruise experience, having already been a ‘cruiser’ on the Alsaka SQLCruise in 2011, the term ‘Washy Washy’ will always be with me, maybe you should also ask Tim Ford about the Oreo challenge (it’s harder than it looks) This 2013 Miami SQL Cruise I was also fortunate enough to be chosen as one of their technical leads, I was indeed in good company as this listing shows http://sqlcruise.com/2013-trainers/
SQL CRUISE LEARN. NETWORK. RELAX. GROW… JUST ADD WATER