locked
Profile a long running SSRS RRS feed

  • Question

  • Hi, 

    Have a long running SSRS report that I would like to monitor in SQL profiler.

    I'm running the report from my browser which accesses the report from a dedicated SSRS server which I don;t have  access to.

    If I run the profiler on my machine but connected to the instance the report uses, how do I filter to see events related to this report? I tried the filtering on ClientProcessID but this showed no data.  Any ideas? 

    Just need to know which filters to set to see which stored procedure takes a long time.  This report uses about 10 stored procedure and accesses four different instances via linked servers.  

    Thanks in advance. 

    Friday, September 19, 2014 12:41 PM

Answers

  • Hi DaveRstad,

    According to your description, you want to monitor the events related to reports and see which stored procedure takes longest time. Right?

    In SQL Server, the SQL profiler monitors the events related to the connected instance. There's no filter dedicated for SSRS reports. If you filter on Client ProcessID and it returns no data, it means no event is active. In this scenario, since you just want to monitor the stored procedure, we suggest you click "show all events", and select related stored procedure when creating Trace.

    If you have any question, please feel free to ask.

    Best Regards,
    Simon Hou

    Tuesday, September 23, 2014 10:12 AM
  • Hi Dave,

    In addition to Simon's recommendations. Can you negotiate access to the ReportServer database?http://msdn.microsoft.com/en-us/library/ms159110.aspx

    Kind Regards,

    Kieran.


    Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/

    Tuesday, September 23, 2014 5:23 PM

All replies

  • Hi DaveRstad,

    According to your description, you want to monitor the events related to reports and see which stored procedure takes longest time. Right?

    In SQL Server, the SQL profiler monitors the events related to the connected instance. There's no filter dedicated for SSRS reports. If you filter on Client ProcessID and it returns no data, it means no event is active. In this scenario, since you just want to monitor the stored procedure, we suggest you click "show all events", and select related stored procedure when creating Trace.

    If you have any question, please feel free to ask.

    Best Regards,
    Simon Hou

    Tuesday, September 23, 2014 10:12 AM
  • Hi Dave,

    In addition to Simon's recommendations. Can you negotiate access to the ReportServer database?http://msdn.microsoft.com/en-us/library/ms159110.aspx

    Kind Regards,

    Kieran.


    Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/

    Tuesday, September 23, 2014 5:23 PM