Post reply

who killed the process

  • August 19, 2011 at 10:03 am

    #243540

    Hi,

    Is there any why we can track who killed the process and what process they had killed.

    If i watch in SQL Server Logs i can see a message like this

    Process ID 60 was killed by hostname servername, host process ID 3036.

    I can see spid over there but when i try to find that information through sp_who2 i cant find the information for that spid .

    I need to find the information through TSQL.

    What is the user name who killed the process and what process they had killed and what time the user had killed the process.

    I am using SQL Server 2008 r2 enterprise edition 64 bit..

    I had some sql server 2000 databases and some sql server 2008 databases on the sql server 2008 r2 enterprise edition 64 bit. My sql servers are running on windows server 2008 ent 64 bit edition.

    Please let me know.

    Thank You very much for your time .

    Thank You,

  • August 19, 2011 at 1:10 pm

    #1370957

    Try to download Adam Machanics sp_whoisactive . That might help you the most. But if you see it in the error log after a long time, the only way you can find any details is either looking at the default trace or look in the servers event log / Security and try to co relate the logon time to KILL time.

    -Roy

  • August 19, 2011 at 3:00 pm

    #1370985

    I will download the script which you had recommended. i will check the event log security also.

  • August 23, 2011 at 8:03 pm

    #1372327

    Hi Roy Ernest,

    I was able to find the requested information through the dmv sys.dm_exec_sessions

    Thank You very much for your help

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

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