BI performance counter: Total rows sent

Applies to

SSAS

Description

This performance counter relates to the measurement of Analysis Services storage engine queries and it measures the total rows of data sent by Analysis Services to client applications, in response to queries.

The value of this counter is reset whenever the service is restarted. This should give you a better visibility into how your network cards are performing and how much of that is related to Analysis Services activity.

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. Ensure SQL Server browser is running
  3. Add an allow incoming rule either on TCP port 1433 or the database engine service

Additional research

SSAS Performance Monitor Counters
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