What does Visual Studio do when it's "loading"

Question

Post reply

What does Visual Studio do when it's "loading"

Thom A

SSC Guru

Points: 99126
More actions
May 27, 2016 at 4:51 am

#327271

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gaja Right there with Babe Points: 768 More actions · Answer 1

Check if there are any filters on Dataset and report itself.

Thom A SSC Guru Points: 99126 More actions · Answer 2

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

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 3

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

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)