patternsqlMinor
why do SSRS reports run longer for a particular user
Viewed 0 times
ssrsreportswhylongeruserforparticularrun
Problem
We have been receiving complaints from a particular SSRS user that her reports run slow. I investigated in the
Fairly consistently, the
I am puzzled. The reports all use the same shared data source that runs as a service account. I would think if it was a crappy user computer issue, I would see differences in the rendering time. Same if there was a network issue.
I don't know where else to look - any ideas?
ExecutionLog table in the ReportServer database and I observed something strange.Fairly consistently, the
TimeDataRetrieval is much longer than other users. Both TimeProcessing and TimeRendering are near the averages of other users.I am puzzled. The reports all use the same shared data source that runs as a service account. I would think if it was a crappy user computer issue, I would see differences in the rendering time. Same if there was a network issue.
I don't know where else to look - any ideas?
Solution
Converted to answer, per OP.
Check the SET settings for her session (sys.dm_exec_sessions). I wonder if she has different SET ARITHABORT or other settings compared to the other users, in which case she might be getting a different plan for the same underlying query.
Check the SET settings for her session (sys.dm_exec_sessions). I wonder if she has different SET ARITHABORT or other settings compared to the other users, in which case she might be getting a different plan for the same underlying query.
Context
StackExchange Database Administrators Q#18325, answer score: 5
Revisions (0)
No revisions yet.