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.
DBAs, Server administrators, Network administrators
- Reduce the amount of data transmitted over the network
- Keep those attributes in your dimensions that truly can be used for analytics
- 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
- Consider using SSIS to spread out the processing of cubes