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
WMV Video 231 MB