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

 

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