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 to organisations in the UK and Europe. Prior to this, Christian worked for 5 years as a Senior Premier Field Engineer for Microsoft UK working with some of Microsoft’s biggest customers. He is a Microsoft Certified Architect, Certified Master and MVP for SQL Server, and lead author of Professional SQL Server 2008 Internals and Troubleshooting. He works out of London and lives in the south of England with his wife and children and can be contacted through http://coeo.com.