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

⇐ Back to index