1

I have a report in a BIDS project that has been deployed to our SSRS Web Portal. On the web, it renders within seconds. In BIDS, it takes upwards of seven minutes. I can see that the query runs against the database quickly - what in the world is BIDS doing that is taking so long?

I have seen this happen in a number of different cases...

1 Answer 1

2

If your query is returning a lot of rows across a slow WAN link then you might be seeing a slowdown due to network traffic. I have that class of problem where I'm working now.

If you report server is on the same fast LAN as the database server it would be quicker under these circumstances. This might explain the difference in performance.

Also, if you have virus scanning software running on your PC it could interfere with the local processing in a variety of ways - scanning the .data file etc. Often real-time scanning also hooks into memory allocation and scans data segments of applications. This really slows down managed applications.

Those are a couple of possibilities that come to mind. There may be other causes as well.

2
  • Great ideas - thanks much. I'm going to see if I can dig deeper into these possibilities.
    – JHFB
    Commented Mar 29, 2012 at 14:51
  • I know running an SSIS package in BIDS/SSDT is slower than executing it from the commandline due to the debug wrapper it uses. Perhaps something similar also occurs with SSRS? Deploy reports to localhost to evaluate it
    – billinkc
    Commented Apr 24, 2012 at 14:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.