16/06/2009 6:27:24 AM
Brad M McGehee, SQL MVP and author is visiting our shores from the US.
While many DBAs may understand SQL Server 2005/2008 Profiler basics, not too many know how to tap the full potential of this important tool. In this session, you will learn many advanced techniques you can use to troubleshoot both SQL Server problems and performance issues, including:
* How to Identify and Analyze Slowly Performing Queries;
* How to Identify Deadlocking Issues;
* How to Identify Blocked Processes;
* How to Identify Memory Warnings,
* How to Identify Excessive SP Compilations;
* How to Identify Issues with SP Cache Activity;
* How to Correlate Profiler and System Monitor Data.
Given the limited time available, not every possible use of Profiler can be discussed. But by learning these specific examples, the DBA will begin to have a fuller appreciation of what Profiler can do for them.
About the presenter:
Brad was the founder of the popular community site SQL-Server-Performance.Com, and operated it from 2000 through 2006, where he wrote over one million words on SQL Server topics.
A well-respected and trusted name in SQL Server literature, Brad is the author or co-author of more than 14 technical books and over 100 published articles. His most recent books include “How to Become an Exceptional DBA,” and “Brad's Sure Guide to SQL Server 2008: The Top Ten New Features for DBAs,” and “Mastering SQL Server Profiler.”
Venue: Mechanics' School of Arts, Level 1, 280 Pitt St, Sydney |
Duration 5:30PM Networking (Pizza & Drinks provided) | 6:00PM - 8:00PM Session |
On: Tuesday, 13 October 2009