Platinum Sponsors
 

13th September 2008 Hatfield, Hertfordshire

Skip Navigation Links
RSS
Login or Join
Skip Navigation Links

Session Details - 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
Christian Bolton is a Director and Database Architect for Coeo Ltd, a Microsoft Gold Partner focused on large scale and complex SQL Server projects in EMEA. 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 and Master for SQL Server specialising in High Availability, Scalabilility, and Performance Tuning and is co-author of Professional SQL Server 2005 Performance Tuning published by Wrox. He works out of London and lives in the south of England with his wife and children and can be contacted at http://coeo.com or through his blog at http://sqlblogcasts.com/blogs/christian.

To view the presentation below in full screen double click on it.


Click here to view in local media player

Due to the size of these files we can only provided streamed versions.

Other sessions from this conference

A Testing Time... (Downloads) (Video)
Advanced T-SQL (2005 and 2008) (Downloads) (Video)
Choices, Choices - Loading and Modelling Slowly Changing Dimensions in the SQL Server 2008 Suite (Downloads) (Video)
Data Vizualisation - Make your reports useful to business - No more "Speed Dials" (Downloads) (Video)
Does your cube support your users reporting needs? (Downloads) (Video)
Don't try this at work ! (Downloads) (Video)
End to End Report Creation and Management using Microsoft SQL Server 2008 (Downloads) (Video)
Getting more value from your data through data mining. (Downloads) (Video)
Head in the Cloud... (Downloads) (Video)
How to approach zero downtime database upgrades (Downloads) (Video)
Indexes Basically (Downloads) (Video)
Microsoft's integrated end-to-end BI offering. (Downloads) (Video)
Performance Monitoring Using SQL Server Management Studio - power of Management Data Warehouse (Downloads) (Video)
Small Problem - Simple Solution: Lookup Tables (Downloads) (Video)
SQL Server – Under New Management (Downloads) (Video)
SQL Server 2008 for Developers (Downloads) (Video)
Understanding Query Cache and Query Plans (Downloads) (Video)
Useful Sql'y stuff that I've picked up over the years (Downloads) (Video)
Where’s my data? An introduction to Spatial Queries in SQL Server 2008 (Downloads) (Video)