Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cache Options Expand / Collapse
Author
Message
Posted Tuesday, July 8, 2014 8:50 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 2:50 PM
Points: 233, Visits: 706
I have a report with a long query and so takes a while to come up.
Thats why I am trying to Cache it.
I created a Cache refresh plan of every two hours.
But don't know what I should add in Processing Options , The default is Do not Cache , but how can I use that when I have scheduled a plan.

Its a bit confusing, Can anyone guide?
OR is there a better way in caching?
Post #1590402
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse