Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kinny
Starting Member
2 Posts |
 Posted - 2008-08-07 : 07:06:35
|
| Hello All, I have been delving into a performance issue with our reports in SSRS and have discovered a very strange problem. When the report is ‘view report’ (preview) in Visual Studio they are generated quite quickly, using profiler you can see all the SQL statements being executed in order. However when running the profiler against the web report system, all stored procedures and OLAP queries are repeated twice once ‘view report’ is clicked. For example according to profiler the execution breakdown in Visual Studio for a report: usp_gettypes usp_getlocationnumbers usp_gettimes 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_gettimes usp_getservicemodes usp_gettypes usp_getlocationnumbers usp_gettimes usp_gettimes usp_getservicemodes usp_r109_terminalactivity This is occurring on a new installation of SSRS on a different server, and the OLAP queries are being repeated twice as well. I have created new data sources using a new domain login and this makes no difference. Logs display nothing out of the ordinary. After viewing a number of other reports and they are all doing the same thing. I am going to continue to work out the issue, to try and find a pattern when it repeats (I just discovered that when pre-filling the parameters, some SPs even get repeated once there as well), but if anyone could shed any light that would be great! Anything you can think of! Thanks a heap! ^_^ |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-07 : 13:36:35
|
| do you have any relationships set up between parameters and also used datasets for filling their values? |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-07 : 13:41:10
|
| What Events did you choose for SP in SQL Profiler? Looks like you choose similar. |
|
|
|
kinny
Starting Member
2 Posts |
Posted - 2008-08-08 : 03:46:23
|
| Thanks for the responses!There are relationships set up between the parameters with dependancies. But this is what occurs after all the parameters have been completed and 'view report' is clicked! The events I chose were all, filtered by login name. (There are alot more statements being fired such as sp_resetconnection etc but they are expected and are duplicated on each)If someone could do me a favor and check profiler and see what one of there paramaterised reports are doing? :)^_^ |
|
|
|
|
|
|
Crazy Reporting Services Double Execution!