Mssql check who is connected

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question. Asked 12 years, 3 months ago.

Active 1 year, 2 months ago. Viewed 1. Are there existing commands to solve this issue? Improve this question. Sklivvz George2 George2 Add a comment. Active Oldest Votes. Improve this answer. Peter Mortensen 29k 21 21 gold badges 97 97 silver badges bronze badges.

Dude, Iman Abidi means crafting your own select query from sys. Is your SQL Server running slow and you want to speed it up without sharing server credentials?

In my Comprehensive Database Performance Health Check , we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future. Leave new Santosh S Pawar. Goran Yordanov. Bob Foxx. Appreciate your SQL articles. I just love them : Thanks, Chinmayee. Pinal Dave. Majid Sayyed. Sandip Parmar. If this option is not enabled, these columns will return null values. For more information about how to set this server configuration option, see common criteria compliance enabled Server Configuration Option.

The "sa" sessions that appear in the resultset, do not have any impact on the user quota for sessions. The non-admin connections will only see information related to their database user sessions. The following example finds the users that are connected to the server and returns the number of sessions for each user. The following example finds the cursors that have been open for more than a specific period of time, who created the cursors, and what session the cursors are on.

The following example finds sessions that have open transactions and are idle. An idle session is one that has no request currently running. Feedback will be sent to Microsoft: By pressing the submit button, your feedback will be used to improve Microsoft products and services. Privacy policy. Skip to main content.

This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Yes No. Any additional feedback? Skip Submit. Time when session was established.