Home Forums Reporting Services Reporting Services SSRS query performance (dynamic SQL vs. stored proc) RE: SSRS query performance (dynamic SQL vs. stored proc)

  • August 16, 2013 at 6:27 am

    #1642123

    Gazareth (8/14/2013)

    Could be a difference in SET options between SSMS & SSRS? (I'm thinking ARITHABORT)

    In my SSMS, I have the SET ARITHABORT checked to on in Tools,Options. I'm not sure where I check that setting in SSRS.

    You can query the TimeDataRetrieval, TimeProcessing, and TimeRendering fields in ReportServer.dbo.ExecutionLog view to find what's taking all the time.

    We have SSRS integrated with SharePoint, so when I query the dbo.Execution log from the SP_ReportServerIntegrated db. Interesting that the only report that shows a Status <> rsSuccess is this particular one with the query issues. I'm going to do more research into these execution times.

    Thanks,

    Rob