30/11/2006 11:31:36 AM
Poorly performing database systems present frustrating problems which DBAs & developers are often placed under pressure to solve and solve quickly. 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
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.
Greg Linwood is the Managing Director of "SQL Servants" - a dedicated Australian SQL Server infrastructure support business and also Australian Director of "Solid Quality Learning" - the world's leading provider of expert SQL Server training. Greg has worked in a range of developer & DBA capacities with SQL Server since 1993 and received Microsoft’s SQL Server MVP award in 2003. He has gained significant expertise in SQL Server tuning & optimisation techniques and most of his professional time is currently spent tuning various 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. He lives in Melbourne with his fiance & two cats. He is a keen pianist & a demon at mini ping pong.
Venue: SA Innovation Centre, L2 Santos House |
Duration 12:00-2:00 |
On: Thursday, 14 December 2006