Share via

  • Article

Proactive Caching (Partition Properties Dialog Box) (SSMS)

Use the Proactive Caching page of the Partition Properties dialog box in SQL Server Management Studio to set the storage and proactive caching properties of a partition in a measure group for a cube in an Microsoft SQL Server Analysis Services database.

Options

  • Standard setting
    Select to enable Standard setting slider and use predefined settings for storage mode and proactive caching features.

  • Standard setting slider
    Set to one of the predefined settings listed in the following table.

    Setting

    Description

    Real-time ROLAP

    Select to use the following storage and proactive caching settings:

    • ROLAP storage mode.

    • Enables proactive caching.

    • Drops outdated cache, with a latency period of 0 seconds.

    • Brings object online immediately.

    Real-time HOLAP

    Select to use the following storage and proactive caching settings:

    • HOLAP storage mode.

    • Enables proactive caching.

    • Drops outdated cache, with a latency period of 0 seconds.

    • Updates cache when data changes, with a silence interval of 0 seconds and no silence override interval.

    • Brings object online immediately.

    Low-latency MOLAP

    Select to use the following storage and proactive caching settings:

    • MOLAP storage mode.

    • Enables proactive caching.

    • Drops outdated cache, with a latency period of 30 minutes.

    • Updates cache when data changes, with a silence interval of 10 seconds and a silence override interval of 10 minutes.

    • Brings object online immediately.

    Medium-latency MOLAP

    Select to use the following storage and proactive caching settings:

    • MOLAP storage mode.

    • Enables proactive caching.

    • Drops outdated cache, with a latency period of 4 hours.

    • Updates cache when data changes, with a silence interval of 10 seconds and a silence override interval of 10 minutes.

    • Brings object online immediately.

    Automatic MOLAP

    Select to use the following storage and proactive caching settings:

    • MOLAP storage mode.

    • Enables proactive caching.

    • Updates cache when data changes, with a silence interval of 0 seconds and no silence override interval.

    Scheduled MOLAP

    Select to use the following storage and proactive caching settings:

    • MOLAP storage mode

    • Enable proactive caching

    • Updates cache periodically, with a rebuild interval of 1 day

    MOLAP

    Select to use the following storage and proactive caching settings:

    • MOLAP storage mode.

  • Custom setting
    Select to explicitly set storage mode, proactive caching, and notification options.

  • Options
    Click to display the Storage Options dialog box to explicitly set storage mode, proactive caching, and notification options. For more information about the Storage Options dialog box, see Storage Options Dialog Box (Analysis Services - Multidimensional Data).