Post reply

Concurrent Queries

  • December 12, 2019 at 12:58 am

    #3707220

    Hi All,

    I would like to know how many concurrent queries running in SQL server

    How do I get that information , any script  ?

    Thank you very much for your feedback

    Much appreciated

  • December 12, 2019 at 1:16 am

    #3707222 

    SELECT sqltext.TEXT,
           req.session_id,
           req.status,
           req.command,
           req.cpu_time,
           req.total_elapsed_time,
           CONCAT(req.total_elapsed_time/1000,' secs') elapsed_secs,
           CONCAT(req.total_elapsed_time/1000/60,' mins') elapsed_mins
      FROM sys.dm_exec_requests req
     CROSS APPLY sys.dm_exec_sql_text(req.sql_handle) AS sqltext

  • December 13, 2019 at 3:17 am

    #3707563

    Thanks for the response Jonathan

    I executed the query and don't get the expected result

    Attached is the result

    I cant see the number of queries running

     

     

     

    Attachments:
    You must be logged in to view attached files.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply