Friday, May 04, 2012 2:15 AM
I've got a report whose underlying query runs quickly in toad, but the report is waaaaaay slower. There's not much happening in the report itself. After googling around I saw the parameter-sniffing thing discussed, but only in reference to mssql data sources. Can the same thing happen with oracle as the back end?
- Edited by sherifffruitfly2 Friday, May 04, 2012 4:13 AM
Friday, May 04, 2012 3:44 AMModerator
can you please do some profiling and see what going on one the server when you run the report
Monday, May 07, 2012 3:37 AMModerator
To troubleshoot the report performance, you can query the “ExecutionLog3” view from the Report Server database.
SELECT TOP 1000 [InstanceName]
Order by [TimeStart] DESC
We can analyze the TimeDataRetrieval, TimeProcessing and TimeRendering values to troubleshoot performance issue. Here are some articles for your reference, please see:
Troubleshooting Report Performance: http://technet.microsoft.com/en-us/library/bb522806.aspx
Report Server Execution Log and the ExecutionLog3 View: http://technet.microsoft.com/en-us/library/ms159110(v=sql.105).aspx
TechNet Community Support
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Monday, May 14, 2012 1:11 AM