Category Archives: database

different database

SQL-Server admin sqlQuery to view the running stats on the server

SQLServer 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:

  1. get list of connected users and its sessions
  2. get list of long running cursor
  3. get list of idle session that has open transaction(s)
  4. get information about own query and connection info
  5. Get information about blocked request

Continue reading SQL-Server admin sqlQuery to view the running stats on the server