Applies to
SSAS
Description
This performance counter relates to the measurement of Analysis Services Proactive Caching.
It monitors the average rate of notifications of Analysis Services cube by the underlying source relational database.
Once the cube has been notified of data changes, measure group partitions are always processed using Full Process which discards the contents of the partition and rebuilds it; dimensions are processed using Process Update which picks up inserts, updates, and deletes in the relational data source.
Resolved by
DBAs, Server administrators, BI developers
Suggested solutions
- In order to generate notifications, SSAS must connect to the SQL Server with administrator rights
- For Client Initiated notification use SSIS to send a NotifyTableChange XMLA command to the SSAS server
- Monitor SQL Server logs for data notifications
Additional research
Near Real Time OLAP using SSAS Proactive Caching
Proactive Caching in SSAS
Why doesn’t SSAS cache the entire cube?
Performance Counters (SSAS)