May 27, 2016 at 4:51 am
Hi All,
I have a report which has been going out for a couple of years. Unfortunately someone has requested a change, which requires quite the overhaul of the data in the back end, but wants the report to remain the same (joy!).
To ensure that everything looks right, I've been stripping out each part of the report and working on them individually. I'm working on a graph at the moment (pretty simple, just showing sales figures for this and last year against each other), however, the "loading" time in Visual studio is extreme. I've been waiting over 5 minutes for it to load now and it's still not done. The dataset is fine, I can run it in SSMS in 3 seconds, so what is VS actually doing..? MY CPU is idle, my RAM usage isn't going up, so VS seems to just be keeping me on my "toes" because it feels like it.
Can anyone give any advice?
Many thanks.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 28, 2016 at 11:11 am
Check if there are any filters on Dataset and report itself.
May 29, 2016 at 6:55 am
Gaja (5/28/2016)
Check if there are any filters on Dataset and report itself.
No filters, just groupings. This doesn't really answer why it takes 10 minutes to "load". There's not many rows of data (maybe 60 at most). If Microsoft Excel can do the maths and produce a graph in the blink of an eye, what is causing SSRS to take so long? Considering it's running on SQL Server back end, something seems "wrong", as I know our SQL Server has far more processing power than my desktop.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 29, 2016 at 7:43 pm
It sounds like it's either waiting for a connection or waiting for a resource that is blocked. You might want to try running sp_who2 from SSMS to take a first crack at the possible blocking problem.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply