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

sql-server reporting-services sql-server-profiler
Moe Sisko picture Moe Sisko · Feb 2, 2012 · Viewed 9.6k times · Source

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

Oleg Dok picture Oleg Dok · Feb 2, 2012

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

Related questions

SQL variable to hold list of integers

I'm trying to debug someone else's SQL reports and have placed the underlying reports query into a query windows of SQL 2012. One of the parameters the report asks for is a list of integers. This is achieved on the report …

Read More
Add alternating row color to SQL Server Reporting services report

How do you shade alternating rows in a SQL Server Reporting Services report? Edit: There are a bunch of good answers listed below--from quick and simple to complex and comprehensive. Alas, I can choose only one...

Read More
Tablix: Repeat header rows on each page not working - Report Builder 3.0

I have a tablix with lots of rows that span over multiple pages. I have set the Tablix property Repeat header rows on each page but this does not work. I read somewhere that this is a known bug in …

Read More