BI performance counter: Total failures

Applies to

SSAS

Description

This performance counter monitors the total number of failed client connection attempts to the Analysis Services instance since the counter was started. An increased value of this counter may indicate invalid logins. The value of this counter is reset whenever the Analysis Services service is restarted.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

  1. Verify users who have access to Analysis Services instance
  2. Verify SQL Server Analysis Services TCP/IP for remote connectivity
  3. Ensure that firewall is not blocking connections from client to server
  4. Check if the SQL Browser service is started

Additional research

SSAS Performance Monitor Counters
Performance Counters (SSAS)
Why doesn’t SSAS cache the entire cube?

 

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