SQL Server Reporting Services

Clear SSRS Report Cache

We’re using SSRS caching for a number of reports in our organization; typically those with relatively fixed date ranges and brands. Many of our reports are for “yesterday” or WTD (week to date) so caching has been implemented to speed up report run times for up to 100 stakeholders.

Every so often though a report cache needs to be cleared so that the freshness of the data can be updated. Perhaps ETL had an issue overnight but someone in Finance ran some ad hoc reporting before you could complete. If you need to refresh the cache for a particular report, this works well for us:

Share on Google Plus

Mike250

Australian living. Sport. Passionate Cricket Fan. Go Pro. Abseiling. Snorkeling. Travel. Golf GTI. SQL Server Developer. Three sons. One daughter.

Leave a comment

Your email address will not be published. Required fields are marked *