Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question

1 Answer 1

up vote 2 down vote accepted

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.

share|improve this answer
    
Great ideas - thanks much. I'm going to see if I can dig deeper into these possibilities. –  JHFB Mar 29 '12 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 Apr 24 '12 at 14:23

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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