Title: SQL Profiler for Developers

Andy Warren

Andy Warren

Target Audience: All skill levels

Profiler isn't just for DBA's. It's an indispensable tool for any developer working with SQL Server. It's not hard to use, but the options and the volume of output can be overwhelming. We'll look at how to reduce the noise by focusing on the most common events and doing some filtering, learn to save the output to a table for deeper analysis (and use a free third party tool to do some killer aggregations!). We'll see how easy it is to find statements that are blocking and learn how to capture the actual query plan being used by those 'bad' queries. Time permitting, we'll also look at some interesting capabilities related to profiling available directly from SSMS and take a quick look at extended events.

Back