Hi, Can any one answer my following questions about the ssrs report manager cache/snapshot/null delivery subscription? 1) What is the location where in which snap shot and cache will be stored? 2) Suppose i have a report having parameters, Then what is the difference between cache creation option in 'Processing option' and 'cache refresh option'? Can i configure both setting at a time for same report?If yes,how it will behave(in the case of cache) for my report? 3)I have read about subscription with 'null delivery provider'. that will create a cache and the old copy must be expired if it is required to deliver new copy. So we have to configure cache expiration setting in 'processing option'.So here my question is: If i create a null delivery subscription on my parameterised report and configured the expiration time in 'processing option' ,It will create many number of cache for that report if user rendering the report with different parameters right?   Thank You in advace... :)

Hi, Report snapshots in SSRS represent reports containing retrieved data at a specific time. Report snapshots also contain your report layout information. Report snapshots are stored in ReportServer database in your SQL Server instance. In the other hand, in report caching process the requested reports and save the results in ReportServerTempDB database. Actually cache refresh creates a schedule to pre-load the cache with the specified values for parameters. But, in Processing options you are creating a cache, so the difference is creating cache and refreshing created cached reports. null delivery provider is a way to pre-load the cache to improve your server performance. For more information read the thread below: 2. Create a data-driven subscription that uses the Null Delivery Provider. When you specify the Null Delivery Provider as the method of delivery in the subscription, the report server targets the report server database as the delivery destination and uses a specialized rendering extension called the null rendering extension. In contrast with other delivery extensions, the Null Delivery Provider does not have delivery settings that you can configure through a subscription definition... CheersMCP, MCTS, MCITP

Hi, Report snapshots in SSRS represent reports containing retrieved data at a specific time. Report snapshots also contain your report layout information. Report snapshots are stored in ReportServer database in your SQL Server instance. In the other hand, in report caching process the requested reports and save the results in ReportServerTempDB database. Actually cache refresh creates a schedule to pre-load the cache with the specified values for parameters. But, in Processing options you are creating a cache, so the difference is creating cache and refreshing created cached reports. null delivery provider is a way to pre-load the cache to improve your server performance. For more information read the thread below: 2. Create a data-driven subscription that uses the Null Delivery Provider. When you specify the Null Delivery Provider as the method of delivery in the subscription, the report server targets the report server database as the delivery destination and uses a specialized rendering extension called the null rendering extension. In contrast with other delivery extensions, the Null Delivery Provider does not have delivery settings that you can configure through a subscription definition... CheersMCP, MCTS, MCITP

Hi, Thanks for reply.. I have noticed that,when i create a cache refresh plan, 1) Data is being populated on 'dbo.ExecutionCache' and 'SnapshotData' table present in ReportServerTemp DB.What is the reason for same(name) 'snapshotdata' table on both DB? 2)If we are not setting Processing options, it is creating multiple cache on the 'dbo.ExecutionCache' table.So,which cache will be used when user click on the report? But this multiple cache wont be created if we are setting only null delivery snapshot.

Hi NikkRED, A report snapshot is a report that contains layout information and data that is retrieved at a specific point in time. The report data will not change if we configure the report run from snapshot. Caching is a performance-enhancement technique. If we configure the report run from cache and user view it firstly, the report data will cache in ReportServerTempDB. However, if a report can contain different data based on query parameters, multiple versions of the report may be cached at any given time. For example, suppose you have a parameterized report that takes a region code as a parameter value. If four different users specify four unique region codes, four cached copies are created. In addition, the Null delivery is used by administrators in data-driven subscriptions to improve report server performance by preloading the cache. Here are some articles about report snapshots and caching reports for your referece, please see: Setting Report Processing Properties: http://technet.microsoft.com/en-us/library/ms159241(v=sql.105).aspx Subscriptions and Delivery (Reporting Services): http://technet.microsoft.com/en-us/library/ms159762.aspx Regards, Bin Long Bin Long TechNet Community Support