Home Forums Reporting Services Reporting Services SSRS query performance (dynamic SQL vs. stored proc) RE: SSRS query performance (dynamic SQL vs. stored proc)
Gazareth
One Orange Chip
Points: 27737
More actions
August 14, 2013 at 8:51 am
#1641442
Could be a difference in SET options between SSMS & SSRS? (I'm thinking ARITHABORT)
You can query the TimeDataRetrieval, TimeProcessing, and TimeRendering fields in ReportServer.dbo.ExecutionLog view to find what's taking all the time.