Yesterday we started seeing some reports fail. The report contains 2 subreports. Subreport 1 contains 3 charts. Subreport runs fine on its own, but all of the sudden it is timing out on the main report when I run it on a remote machine through the web interface. It "sometimes" also runs fine and sometimes times out on the report server.
I am seeing this command being executed when I query DMVs
select * from {IRowset 0x2002E2A600000000}
Anyone know what this is?