Adrian Hills • 2/17/2010

Using the SP:StmtCompleted SQL Profiler trace event class

This technical article addresses a common SQL Server performance tuning question: how to pinpoint which specific statements inside a stored procedure are consuming the most time. It critiques clunky manual timing methods and recommends using the often-overlooked SP:StmtCompleted event class in SQL Profiler. This approach provides a detailed trace of each statement's execution, offering a cleaner alternative to modifying code for auditing.

0 comments

#profiler #performance tuning #SQL Server