Been troubleshooting an issue for a couple weeks now, where a couple reports are running really slowly. These aren't terribly complex reports, they just grab data and do a little aggregation/sorting and display it. No charts or anything. Prior to last Monday both reports ran just fine. There are still some reports that run quickly, but they deal with very small amounts of data and even less processing.
I've verified that parameter sniffing isn't the problem, the report itself works fine both in visual studio and on a test reporting server (even when pointing to the production database.)
So I think it's a problem with the server itself. The sys admin has ruled out any "hardware" issues, with hardware in quotes because it's a VM. The server has plenty of memory as well. We even tried disabling anti-virus.
Here are the times listed from the ExecutionLog table. You can see that the data retrieval is pretty close for both servers but the rendering time is way higher in production.
Server TimeDataRetrieval TimeProcessing TimeRendering production 114353 4075 189073 test 140716 3295 1101
So any ideas why the report is taking so long to render on the production server?