BI performance counter: Total bytes sent

Applies to

SSAS

Description

This performance counter relates to the measurement of Analysis Services storage engine queries and it measures the total bytes sent by Analysis Services to client applications, in response to queries. The value of this counter is reset whenever the service is restarted.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

  1. Use netstat command-line network utility tool to look for any signs of dropped packets
  2. Use SQL Server Profiler to see what queries get sent to the server
  3. Try to use faster storage (SSD) or more disk drives for quicker responses to Storage Engine requests

Additional research

Counting Number of Queries Executed in SSAS
Performance Counters (SSAS)
Performance Counters for SSAS 2008

 

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