BI performance counter: Current connections

Applies to

SSAS

Description

This performance counter measures the current number of active client connections established at a point in time.

The value fluctuates as connections are established and dropped. Analyze the value of this counter in conjunction with Query Pool Thread counter.

Resolved by

DBAs, Network administrators

Suggested solutions

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

Additional research

Troubleshooting Common SQL Server Analysis Services Connectivity Issues
Performance Counters (SSAS)
Performance Monitoring for SSAS – Perfmon Counter Cheat Sheet

 

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