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

Question

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?

Answer 1

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