ReportServer
|
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
|
Thursday, April 14, 2011
Difference Between ReportServer Database Vs ReportServerTempDB
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment