SQL Server 2012 SSRS Caching

by

SQL Server 2012 SSRS Caching Q&A

Question 1: While a report is caching, and a user queries a report at the same time, what happens (do they get the old version or does it ask them to wait)?
Answer 1: They see the old version till the new one is made available – assuming the 1st snapshot has already been generated

Question 2: With snapshot, and a user queries a report at the same time, what happens (do they get the old version or does it ask them to wait)?
Answer 2: Same as cache, except cached instance are subject to expiration. If expired, they’ll need to wait.

Question 3: Will a report get cached if no one requests the report?
Answer 3: No, unless you use something like a Data Driven Subscription (DDS) to force it to cache.  Also, be aware that each distinct set of query parms may create a separate cached instance. Obvious size ramifications.  Also, something to be aware of if using a DDS to pre-cache the reports.

For more information and a free consult, please contact Henson Group at http://www.thehensongroup.com/Pages/Default.aspx or 800-980-1130.

Tags: ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: