2012-03-28 17:56:34 8 Comments

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


@ConcernedOfTunbridgeWells 2012-03-29 12:50:43

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.

@JHFB 2012-03-29 14:51:46

Great ideas - thanks much. I'm going to see if I can dig deeper into these possibilities.

@billinkc 2012-04-24 14:23:10

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

Related Questions

Sponsored Content

5 Answered Questions

[SOLVED] Why does this query become drastically slower when wrapped in a TVF?

2 Answered Questions

[SOLVED] SSRS: First report is slow: Reloading Appdomain

1 Answered Questions

1 Answered Questions

1 Answered Questions

[SOLVED] How should I deploy these SSRS reports?

1 Answered Questions

[SOLVED] async_network_io issues with BIDS

1 Answered Questions

[SOLVED] Why does it take so long to calculate an Execution Plan?

Sponsored Content