We have been receiving complaints from a particular SSRS user that her reports run slow. I investigated in the 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?
Best Answer
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.