Concurrent Queries

  • WhiteLotus

    SSChampion

    Points: 11908

    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

  • Jonathan AC Roberts

    SSCoach

    Points: 17091

    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
  • WhiteLotus

    SSChampion

    Points: 11908

    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 3 (of 3 total)

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