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 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. ⇐ Back to index
