Brian H. Madsen
3/7/2006 5:15:29 PM
**** Registration Closed
**** contact firstname.lastname@example.org if you
**** wish to be added to tonights event.
So, we're at it again. After another extended break (due to lack of presenters here in Perth) we have Greg Linwood coming over and presenting for us.
Further details will be published as soon as they've been confirmed but for now check out the details below:
Title: Professional Performance Tuning SQL Server
Presenter: Greg Linwood
Poorly performing database systems present frustrating problems which DBAs & developers are often placed under pressure to solve as quickly as possible. Although a significant amount of literature has been published about how to solve individual performance problems or how to interpret specific performance counters there is little information available that "joins-the-dots" to lead DBAs & developers through the myriad of techniques & tools available for performance tuning SQL Server.
In this session Greg Linwood steps through a database performance tuning methodology, describing how to use the available SQL Server toolset & commands to quickly and effectively identify, analyse and resolve performance problems.
Practical techniques will be demonstrated, including:
* How to make effective, holistic observations of the entire database system
* How to create effective SQL Profiler traces
* How to choose which Perfmon counters to monitor
* Reading & Interpreting execution plans
* Using documented (& undocumented) system commands & views
* How to benchmark performance information with constant monitoring techniques
Improvements in SQL Server 2005's performance tuning toolset will also be covered.
This session focuses on locating and solving performance problems in database systems which are already deployed, but is also invaluable to developers who wish to design more efficient database systems. The session will wrap up with a Q&A session with the presenter.
Be sure to register online to ensure spots are available and that I can have food and drinks for everybody.
Secondly - www.fasthit.net - a WA based hosting provider is providing this months price. a Business.Net hosting plan 12 months free (valued at $633.60). The draw will be held amongst those that sign up/register online prior to 2pm, 23rd of March.
Thanks to www.fasthit.net for the generous prize!
Venue: 255 St Georges Tce, QV1, Level 14. Microsoft Offices - 5:00pm to 7:00pm |
Duration 2hrs |
On: Thursday, March 23, 2006