O'Reilly logo

SQL Server 2016 Reporting Services Cookbook by Robert C. Cain, Dinesh Priyankara

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Refreshing the cache

Did you notice an issue with the previous recipe related to caching? I am sure that you have. The first issue is that it uses the cache continuously if the shared schedules set of expiring the cache is paused. Since the cache does not get expired, users will not get a fresh copy even after the scheduled time.

The second issue is, if the schedule set for expiring the cache is expired or not available, Reporting Services will not create a cache instance for the report again. Since Reporting Services does not to create the cache, performance of the report rendering becomes poor as it always needs to get the required data from the source.

We need to make sure that the caching we have enabled is continuously functioning even with ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required