none
ssrs caching and history snapshots RRS feed

  • Question

  • Hi,

    I’m a ssrs newbie, and I was confused about the difference between caching and history snapshots.

    Any help is greatly appreciated.
    Monday, June 29, 2020 12:17 PM

Answers

  • Hi vera.S,

    Caching stores a copy report data and report structure for later executions of the report. It has expiration. You can have only one "instance" per report (if you have parameters, you will have one per combination of parameter).

    A history snapshot is a report that contains layout information and data that is retrieved at a specific point in time, which allowing you to time exactly when report and data processing will occur.  It is a persisted copy of the report. It is stored in the intermediary form in the ReportServer database, where it is subsequently retrieved when a user or subscription requests the report. You can have multiple copies per report.

    Please refer to the following articles for more details:

    Caching vs Report Snapshot in SSRS

    SSRS Report Execution Snapshot vs. a Report History Snapshot

    Hope this could help you.

    Best Regards,

    Amelia


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by vera.S Tuesday, June 30, 2020 11:34 AM
    Tuesday, June 30, 2020 2:25 AM
  • Hi vera.S,

    Did the answer above help you?

    Please feel free to let us know if you have any other question.

    If you find any post in the thread is helpful, you could kindly mark it as answer. This would benefit the community, and encourage the community member to keep working on your issues.

    Best Regards,

    Amelia


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by vera.S Tuesday, June 30, 2020 11:34 AM
    Tuesday, June 30, 2020 9:28 AM

All replies

  • Hi vera.S,

    Caching stores a copy report data and report structure for later executions of the report. It has expiration. You can have only one "instance" per report (if you have parameters, you will have one per combination of parameter).

    A history snapshot is a report that contains layout information and data that is retrieved at a specific point in time, which allowing you to time exactly when report and data processing will occur.  It is a persisted copy of the report. It is stored in the intermediary form in the ReportServer database, where it is subsequently retrieved when a user or subscription requests the report. You can have multiple copies per report.

    Please refer to the following articles for more details:

    Caching vs Report Snapshot in SSRS

    SSRS Report Execution Snapshot vs. a Report History Snapshot

    Hope this could help you.

    Best Regards,

    Amelia


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by vera.S Tuesday, June 30, 2020 11:34 AM
    Tuesday, June 30, 2020 2:25 AM
  • Hi vera.S,

    Did the answer above help you?

    Please feel free to let us know if you have any other question.

    If you find any post in the thread is helpful, you could kindly mark it as answer. This would benefit the community, and encourage the community member to keep working on your issues.

    Best Regards,

    Amelia


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by vera.S Tuesday, June 30, 2020 11:34 AM
    Tuesday, June 30, 2020 9:28 AM