BI performance counter: Notifications/sec

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

  1. In order to generate notifications, SSAS must connect to the SQL Server with administrator rights
  2. For Client Initiated notification use SSIS to send a NotifyTableChange XMLA command to the SSAS server
  3. 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)

 

To track BI performance metrics – consider using ApexSQL BI Monitor, a web application that monitors system, SSAS, SSIS and SSRS performance in real time.

⇐ Back to index