Thursday, April 14, 2011

Difference Between ReportServer Database Vs ReportServerTempDB

It Stores information about the report schema, report property, data sources, parameters, stores the folder hierarchy, report Execution log
It stores only the cached copy of the report data.
It always exists until changes on the RDL Schema
It expires based Expiry settings
It helps to access the structure
It helps to improve the performance of report execution as it is loading data from cache
Data always exists during SSRS service restarts
Services restarts will clear the Temp Data

No comments:

Post a Comment