Applies to

SSAS

Description

Analysis Services can consume considerable amount of network resources during dimension and cube processing. This performance counter measures the total number of network round trips, including all communication between client applications and Analysis Services server. Increased network latency can create bottlenecks that results in longer processing times.

Resolved by

DBAs, Server administrators, Network administrators

Suggested solutions

1. Reduce the amount of data transmitted over the network
2. Keep those attributes in your dimensions that truly can be used for analytics
3. If your source system (SQL Server) and SSAS are both on the same machine, you should consider using the Shared Memory net library for better performance
4. Consider using SSIS to spread out the processing of cubes

Additional research

SSAS Performance – Best Practices and Performance Optimization
SSAS Performance Monitor Counters
Performance Counters (SSAS)
Configure the network packet size Server Configuration Option

⇐ Back to index