Sunday, 30 April 2017
Task Pane 
Login
username:
password:
Remember Me
|Signup
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?







[show results]
SQL Server Memory Management & Tuning (Greg Linwood)
Author: Jeff Wharton Date Posted: 11/02/2009 1:16:13 PM
Memory (RAM) is the most important hardware resource SQL Server uses to achieve high levels of performance. Database systems that lack sufficient memory or are not configured to use available memory properly always perform poorly compared against systems with well configured & adequately sized memory. In this session, we look at how SQL Server uses memory and what you can do to improve the performance of your SQL Server system by sizing & configuring memory properly. Techniques discussed are applicable to SQL Server 2000, 2005 & 2008 and include:

* How to identify whether your system has sufficient memory
* How to configure your server to use all available memory
* How to monitor your system, tracking memory usage over time


Greg Linwood is the Managing Director of "SQL Servants" - a dedicated SQL Server support business and also Australian Director of "Solid Quality Learning" - a specialist provider of SQL Server training. Greg has worked in a range of developer & DBA capacities with SQL Server since 1993 and was the first Australian to receive Microsoft’s SQL Server MVP award in 2003. He has gained significant expertise in SQL Server tuning and most of his professional time is currently spent tuning customer SQL Server systems. Greg is passionate about building high quality SQL Server community events in Australia and is one of the founders of the Australian SQL Server User Group.

Venue: Excom Education, Level 2, 33-35 Ainslie Place, Canberra City (Entrance Map) | Duration Networking from 5:30PM for a 6:00PM Start | On: Tuesday, 5 May 2009