About the Presentation
Getting the Most Out of the SQL Server Profiler
While many DBAs may understand SQL Server 2005/2008 Profiler basics, not too many know how to tap the full potential of this important utility. In this session, DBAs 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 Excessive SP Compilations, How to Identify Excessive Table/Index Scans, How to Identify Memory Problems, and 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 f
Session Level: Advanced
Brad McGehee
Brad M. McGehee is a MCSE+I, MCSD, and MCT (former) with a Bachelors’ degree in Economics and a Masters in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is an accomplished Microsoft SQL Server MVP with over 14 years’ SQL Server experience, over 6 years’ training experience, and has been involved in the industry since 1982.
Brad is a frequent speaker at SQL PASS, European PASS, SQL Connections, SQLTeach, SQLBits, SQL Saturdays, TechFests, Code Cam
Contact URL:
http://www.sqlservercentral.com/blogs/aloha_dba/default.aspx