BI performance counter: Current user sessions

Applies to

SSAS

Description

This performance counter monitors the total number of active user sessions currently connected to the Analysis Services instance.

A connection is always tied to a session but there could be sessions without active user connections. It is also possible for an application to create multiple sessions over the same connection.

Resolved by

DBAs, Network administrators

Suggested solutions

  1. Use DMVs to Monitor Analysis Services
  2. Use SQL Server Profiler to see who is connected to the server
  3. Ensure that firewall is not blocking connections from client to server
  4. Check if the SQL Browser service is started

Additional research

Use Dynamic Management Views (DMVs) to Monitor Analysis Services
Finding and killing SSAS Sessions
Performance Counters (SSAS)
Performance Monitoring for SSAS – Perfmon Counter Cheat Sheet

See more

Check out SpotLight, a free, cloud based SQL Server monitoring tool to easily detect, monitor, and solve SQL Server performance problems on any device

 

⇐ Back to index