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.

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).

Community Additions

ADD
Show: