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
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?