Proactive Caching and Real-Time Updates - Microsoft SQL Server 2008 Analysis Services - page 445

FIGURE 24.8

You can use SQL Server Profiler to monitor proactive caching events.

Just after that, you see a Notification event with the event subclass “8 - Object
Altered” , and then you see another Notification event with the event subclass “13 -
Proactive Caching: notifiable” . In the Text Data column for that event, you see a
message indicating the time that the next processing will start. All events related to proac-
tive caching are reported in the Notification class of events with different event
subclasses.

After about 20 seconds (in the example, we set the ForceRebuildInterval property to 20
sec ), we see that processing of the Store dimension has begun. You see that all Progress
Report events have the ConnectionID property set to 0 . That is because proactive caching
operations are running as part of an internal subsystem within Analysis Server.