How to get the output of SQL Server Activity Monitor using SQL script?

• sekhar

  Valued Member

  Points: 67

  More actions

  April 21, 2022 at 4:57 am

  #4019701

  Hi,

  I am looking for a SQL query that can give the data present in the "Activity Monitor" like the data shown in the panel's Recent Expensive Queries or Active Expensive Queries?

   

  Attachments:

  You must be logged in to view attached files.

• ktflash

  Default port

  Points: 1400

  More actions

  April 21, 2022 at 9:41 am

  #4019834

  Heres a some selection of columns u can query from DMVs that SQL Server offers.

  SELECT  DER.session_id
     ,DER.status
     ,txt.text
     ,DER.user_id
     ,Database_Name = db.name
     ,total_elapsed_time
  FROM    sys.dm_exec_requests  DER
  inner join sys.databases DB on DER.database_id = DB.database_id
  CROSS APPLY sys.dm_exec_sql_text(sql_handle)  txt

  I want to be the very best
  Like no one ever was

  https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help