Post reply

Help to retrieve information on long running queries utilizing high CPU with the login information

  • September 24, 2014 at 10:10 am

    #311770

    Hi,

    Need help to retrieve information on long running queries utilizing high CPU with the login information in sql 2k8.

    I got the information on long running queries utilizing high CPU using one of dmvs but it didn't give me which user/application was running that long running query. can someone provide or educate on getting that info pls..Appreciate your responses.

  • September 24, 2014 at 10:25 am

    #1747899

    I recommend sp_WhoIsActive that Adam Machanic has provided free to the community. You can download it here.

    If you don't want to go that route you need to be sure you are using:

    sys.dm_exec_connections

    sys.dm_exec_sessions - has login information

    sys.dm_exec_requests - has query and performance information

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • September 24, 2014 at 1:47 pm

    #1747971

    Thanks for the response Jack.

    I don't think we can use third party tool on our PROD. Coming to using dmvs....with sys.dm_exec_sessions I was able to get only the current logins/connections.

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

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