Hello All, I have been delving into a performance issue with our reports in SSRS and have discovered a very strange problem. Essentially it appears that SSRS executes all the SPs required to load the report for a second time once view report is clicked whereas visual studio doesnât. This of course has a heavy impact on performance. After running profiler on a large number of reports I discovered they all doing this, I have created a simple report and found this issue occurs once the report has parameters that are pre-filled with values from a SP. For example according to profiler the execution breakdown in Visual Studio for a report: usp_gettypes usp_getlocationnumbers usp_gettimes usp_getservicemodes usp_r109_terminalactivity However once the report is executed on the web interface the execution breakdown is: usp_gettypes usp_getlocationnumbers usp_gettimes usp_getservicemodes usp_gettypes usp_getlocationnumbers usp_gettimes usp_getservicemodes usp_r109_terminalactivity This is occurring on a new installation of SSRS on a different server. I have created new data sources using a new domain login and this makes no difference. Logs display nothing out of the ordinary. Is this normal behaviour for reporting services? Is there any way to avoid this wasteful double-execution of SPs?
