The Ultimate Running Requests Reporter

  • YeshuaAgapao

    Hall of Fame

    Points: 3495

    Comments posted to this topic are about the item The Ultimate Running Requests Reporter

  • Sankar Reddy

    SSCrazy

    Points: 2410

    Good one. Can you exclude the session_id where this script is running?

    [font="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]

  • Rudy Panigas

    SSChampion

    Points: 10695

    Hello,

    Congrats on the great script. Very useful!

    I have added below a script that would be a great addition to your code. It produces the IP address of the workstation connected. I found it at SQL Central. It would helpful if the user is connected with SQL authentication.

    What do you think?

    Rudy

    SELECT ec.client_net_address AS 'IP Address of Client', es.[program_name] AS 'Name of Application',

    es.[host_name] AS 'Host/Computer Name', es.login_name AS 'ID Used',

    COUNT(ec.session_id) AS 'Connection Count', @@SERVICENAME AS 'Instance User Is Connected To'

    FROM sys.dm_exec_sessions AS es

    INNER JOIN sys.dm_exec_connections AS ec

    ON es.session_id = ec.session_id

    GROUP BY ec.client_net_address, es.[program_name], es.[host_name], es.login_name

    ORDER BY ec.client_net_address, es.[program_name]

    Rudy

  • kevin.karlin

    SSC Rookie

    Points: 45

    Due to the use of Cross Apply, this will only return rows where the Statement and QueryPlans are available. Change it to an OUTER APPLY to gather all spids.

    ie

    OUTER APPLY sys.dm_exec_sql_text(sql_handle) AS Statements

    OUTER APPLY sys.dm_exec_query_plan(plan_handle) AS QueryPlans

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the script.

Viewing 5 posts - 1 through 5 (of 5 total)

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