How can I use SQL Profiler to capture a single stored procedure

by Adam   Last Updated August 14, 2019 01:06 AM - source

Using SQL Server SQL Profiler, which configuration can be used to monitor a single stored procedure? The only trace needed is for the EXEC statement, to include the parameters.

This will be used to load test. I've considered capturing all stored procedure execs and filtering using Power Query or similar, however, the number of total sproc executions makes this impractical.

Related Questions

Sqlserver exec sp_execute to simple query?

Updated March 05, 2018 17:06 PM

Profiling parameters

Updated April 24, 2015 02:02 AM

SQL Server Profiler performance

Updated August 10, 2015 17:02 PM