A walk down memory lane
Understanding memory architecture and how SQL Server uses it can help a great deal
with how you approach performance troubleshooting or setup a new SQL Server and while
a lot of information is available on the topic its often lightweight or very
in-depth with nothing to help join the two. In this session I'll be discussing common topics
like PAE, AWE, /3GB and 64bit along with more advanced subjects concerning SQL Server's
usage in a way that's very accessible to any audience. At the end of the session you will
have a good understanding of the best practices and normal usage profile for SQL Server
memory as well the architecture to help you understand why certain best practices exist
and when they can be flexible.
Christian Bolton is the Technical Director for Coeo Ltd, a leading provider of SQL Server Managed Support and Consulting in the UK and Europe. He is a Microsoft Certified Architect, Microsoft Certified Master and MVP for SQL Server, and lead author of Professional SQL Server 2012 Internals and Troubleshooting.