With the help of SQL Server SQL Profiler, which configuration can be used to monitor a single stored procedure? I would like to capture everything EXEC sprocName include the list of parameters. I would like to capture this procedure to be able to test it using realistic parameter data.
I have tried the following in a new SQL Profiler trace:
Events Selection > Column Filters > Text Data > LIKE: 'exec sprocName%'
Events Selection > Column Filters > Text Data > LIKE: 'exec sprocName'
None of the above configurations capture my procedure. I have also tried to delete the name of the procedure with the following configurations:
Events Selection > Column Filters > Text Data > LIKE: 'exec%'
Events Selection > Column Filters > Text Data > LIKE: 'exec'
The above configurations do not capture any procedure.
Finally, I tried to run the same profile without all column filters and I can confirm that it captures all SQL queries sent to SQL Server.
I envisioned a workaround consisting of capturing ALL of the stored procedure executables and performing a post filter on my sproc of interest, using SQL queries or Excel. Power Query. However, the high frequency of sproc executions in the environment that I want to model makes this operation impractical.
