Jaa

Report Caching

  • Artikkeli

Report Caching is used to improve performance

There are 2 types of caching:

Temporary Cached Report:

– Copy of report in intermediate format stored in the ReportServerTempDB Database.

– Copy is rendered in the desired format when report is requested.

– It is cached on first use.

– Cached copy expires by a predetermined method.

Snapshot Report:

- Is a form of cached report. These reports are built and stored in the Report Server Database in the intermediate format on a predefined schedule and not upon user request.

Report can not be set up to be cached IF:

– Credentials are not stored

- Data Source credentials can not be set to prompt or integrated

Report will not pull from the cache IF:

– Report Parameter Changes

– Report Definition Changes

– Data Source Credentials Change

– Cache Options change

Changing report layout or data source does not affect the saved snapshots

By default, cached reports are saved in ReportServerTempDB

It can be stored in the filesystem, too (saves server round-trips. Only useful for Remote catalogs.)

- This can be configured in RSReportServer.config file

– WebServiceUseFileShareStorage

<Add Key="WebServiceUseFileShareStorage" Value="true" />

– WindowsServiceUseFileShareStorage

<WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>

– FileShareStorageLocation

<FileShareStorageLocation><Path></Path></FileShareStorageLocation>

Default Location : C:\Program Files\Microsoft SQL Server\MSSQL\MSSQL.instance\Reporting Services\RSTempFiles

More information:

SSRS 2008: https://msdn.microsoft.com/en-us/library/ms155927.aspx

SSRS 2005: https://msdn.microsoft.com/en-us/library/ms155927(SQL.90).aspx

Comments

  • Anonymous
    November 19, 2007
    HI Selva, Can you tell me some pointers reg configurating Cacheing in SSRS? i am getting below error if i try to configure caching.. I came to know that i have to store the credentials in the Report server. After storing the credentitals in the  report server using Datasource properties and i tried to acess the report. i am getting following error. • ‘An error has occurred during report processing. o Cannot create a connection to data source '<datasourcename>'. Login failed for user '<user>'. The user is not associated with a trusted SQL Server connection.