SQL-Server: admin SQL Queries to view the running stats. I have used this frequently on SQL-Server 2016 for day to day activities and useful for me most of the time. You can also try this if you are a admin or developer or user of sql server.
In this article, tried to share few tsql/sql server admin queries as:
- get list of connected users and its sessions
- get list of long running cursor
- get list of idle session that has open transaction(s)
- get information about own query and connection info
- Get information about blocked request