9.09.2012

ReportServer DB vs ReportServerTempDB

Difference between ReportServer Database and ReportServerTempDB in SSRS

S.No
ReportServer Database
ReportServerTempDB
1
What it stores ?
It Stores information about the report schema, report property, data sources, parameters, stores the folder hierarchy, report Execution log.
What it stores ?
It stores only the cached copy of the report data.
2
How long it exists ?
It always exists until changes on the RDL Schema.
How long it exists ?
It expires based on Expiry settings.
3
How it helps ?
It helps to access the structure.
How it helps ?
It helps to improve the performance of report execution as it is loading data from cache.
4
Whether data will exist during / after service restart ?
Data always exists during SSRS service restarts.
Whether data will exist during / after service restart ?
Services restarts will clear the Temp Data.

1 comment: