ReportServer DB and ReportServerTempDB databases

Hi all,

Is it possible to cleanup ReportServer DB and ReportServerTempDB by setting the time interval ? For example, I want data in these two dbs to be deleted automatically after 5 or 10 minutes. How can I do that because as new reports are added and executed data goes on increasing in very short time and hurts performance.

Thanks,

Prashant

What data specifically are you trying to clean up? How are you measuring performance to know that this is the root of your problem?|||

Thanks for the reply !

No, there is no problem till now, but the data which is stored in tables like ChunkData, SnapShotData etc. is quite huge as many reports are running. I know, its temporary but is there any way from where I can set the time limit after which it will be cleaned up ?

Also one more thing, if I delete a report, what would happen to data stored in above tables ? Does it (data) get deleted with the deletion of report which populated them or does it remain in tables to be deleted after time limit ?

Thank again,

Prashant

|||

You need CleanupCycleMinutes in rsReportServer.config -- The default is 10 minutes.

<don't get me wrong here...>

It doesn't really sound like you know whether large orphaned snapshots are a perf problem in your scenario...by definition, they shouldn't be, as they are just blobs sitting around doing nothing. Even if you clean up more often, there's no win (unless you are storing snapshots to the filesystem with limited space) as I don't think the databases themselves are going to shrink for you anyway...You could actually make a situation which you think is bad worse by modifying this setting, as there's a cost to running the cleanup process. You don't want it firing all the time, and when most people modify it, the actually bump the value UP to make sure they don't get contention between the "normal" SSRS processes that read/write to these tables and the "cleanup" process.

</don't get me wrong here...>

Hope this helps?

|||

Thanks for opening my eyes ! Now I prefer to leave this cleaning task untouched and let RS take care of it.

Thanks again, Russell

Prashant

sql