User would like to see the number of users connected to the DB.
User would like the Real Time of SQL Server connections.
The equivalent for this in Performance Analysis (PA) would be to show the number of users connected to the Database in a given History period.
PA does show a similar metric with sessions running in a given time period. PA provides three metrics related to Sessions (roughly equivalent to the number of DB users connected to the DB)
Sessions Running : Number of sessions that were active during the current interval
Session Logons: Number of sessions whose activity started during the current interval
Sessions Logoffs: Number of sessions logged out during the current interval
Once you enable these metrics and see them in the History tab, they would be available for printing in Reports as well.
How to enable these metrics:
You can enable the additional metrics from the PA Client Display Options settings (Hammer icon)
- Click on Hammer icon - PA Client Display Options
- Go to Support tab
- Check box -> Advanced Settings -> Enable Grids customization -> Apply
- Now in the GUI, in Real Time or History tab, place cursor in the lower overview pane and right click in a blank area -> Select Metric option is seen
- Click on this option
- Metric Selection dialog box opens up
- Filter list: Session -> you will see Session Running, Logoffs, Logons
Add them and click apply and now you should see the added metrics in Real Time or the History tab.
Number of Sessions is not exactly the same as the Number of Users connected to a DB. A given connected User can have multiple sessions running or a program (using one user name to connect) may run multiple sessions. From a performance perspective, it is the number of sessions per given time period that is more important rather than number of users connected.
An enhancement request to see the Number of DB users connected to the DB has been created.
You can track this enhancement using the following ID: CR0232904
This will be considered in a future release.