Chunkdata

Help is needed on managing the Chunkdata table in the ReportServerTempDB
database. It grows too large after we run reports with a lot of images. I
wonder if it is save to truncate the Chunkdata table if we don't care about
the caching of the report images, the report history or snapshots.
Any help on this issue is greatly appreciated!
TommyDid you manage to resolve this issue? I am getting the same problem, as are
other people.
I have tried TRUNCATE TABLE ChunkData on a nightly basis, which initially
appeared to work, however I think it may have caused some problems with some
specific streamed graphs and the like. To resolve this I RESTORed an older
ReportServerTempDB which got it all going again.
I am going to be trying to RESTORE a ReportServerTempDB from when the
database was small, each night to try and limit this growth.
I can only assume that this is some sort of BUG in the cleanup routines, as
18Gb (the entire disk) is an enormopus amount of caching, for what are
generally only 4 or 5 page reports.
Anyway, if you got anywhere with this, I would be grateful to know.
Thanks in advance.
"Tommy Tao" wrote:
> Help is needed on managing the Chunkdata table in the ReportServerTempDB
> database. It grows too large after we run reports with a lot of images. I
> wonder if it is save to truncate the Chunkdata table if we don't care about
> the caching of the report images, the report history or snapshots.
> Any help on this issue is greatly appreciated!
> Tommy