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
- Use netstat command-line network utility tool to look for any signs of dropped packets
- Use SQL Server Profiler to see what queries get sent to the server
- 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.
