SQL Server Profiler : capture calls to your database's stored procs during SSRS report generation

10.5k Views Asked by At

Using SQL Server/SSRS 2008.

With SQL Server Profiler, I've been unsuccessfully trying to trace SSRS (rdl) report generation calls to my database's stored procs i.e. so I can see what parameter values are being passed etc.

What events should I be looking for?

1

There are 1 best solutions below

3
On BEST ANSWER

Events:

In Stored Procedures group

  • RPC:Completed
  • RPC:Starting (if completed is not called because of error in proc)

If your proc is called as usual Sql Query, then:

In TSQL group

  • SQL: Batch Starting
  • SQL: Batch Completed