The SQL Server is a powerful, but underused tool. Often developers and some DBAs don’t realize the potential the tool has to offer. In this session I will show you how to use the tool to identify poor performing queries. I will also details steps that can be used to identify blocking and deadlocking. Finally, I will provide sample scripts and methods that can be used to proactively monitor your SQL Server for inefficient queries and stored procedures.

Speaker Bio: Patrick LeBlanc is currently a Business Intelligence Architect for Pragmatic Works. He has worked as a SQL Server DBA for the past 9 years. His experience includes working in the Educational, Advertising, Mortgage, Medical and Financial Industries. He is also the founder of TSQLScripts.com, SQLLunch.com and the President of the Baton Rouge Area SQL Server User Group. Patrick is a regular speaker at various SQL Server community events, including SQL Saturday’s, User Groups and the SQL Lunch.

Session Goal#1: Explain how to use SQL Server profiler to identify performance problems.

Session Goal #2: Explain how to use SQL Server profiler to perform server side traces.

Session Goal #3: Explain how to use SQL Server Profiler to identify blocking, deadlocking and other performance problems.

(Please note: cannont click through to speaker details from speaker's name below)