How can I use SQL Profiler to capture a single stored procedure Using SQL Server SQL Profiler, which configuration can be used to monitor a single stored procedure? I'd like to capture all EXEC sprocName to include the parameter list. I'd like to capture this procedure so that I can load test it using realistic parameter data.

I've tried the following in a new SQL Profiler trace:

Events Selection &gt; Column Filters &gt; Text Data &gt; LIKE: 'exec sprocName%'
Events Selection &gt; Column Filters &gt; Text Data &gt; LIKE: 'exec sprocName'


Neither of above configurations capture my procedure. I've also tried to remove the procedure name with the following configs:

Events Selection &gt; Column Filters &gt; Text Data &gt; LIKE: 'exec%'
Events Selection &gt; Column Filters &gt; Text Data &gt; LIKE: 'exec'


Above configs do not capture any procedures.

Finally, I tried to execute the same profile without any column filters and I can confirm that it captures all SQL queries sent to SQL Server.

I've considered a workaround of capturing ALL stored procedure execs and post-filtering to my sproc of interest, using SQL queries or Excel Power Query.  However, the high frequency of sproc executions in the environment I want to model, make this unfeasible.
I would suggest to use Extended Events instead of Profiler as the Extended Events has less overhead and more events to capture compare to Profiler.

In your case, create a new session in Extended Events by selecting rpc_completed event. For detailed steps..