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.
Presented by Christian Bolton at SQLBits III
  • Downloads
    Video available WMV Video 231 MB
  • SpeakerBIO

    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.

  • Video