August 13, 2008 at 12:08 pm
Hi all,
Not sure if this needs to go in the admin section. I need help setting up profiler to determine when a kill command is issued. Recently I'm getting alerts that certain processes are being killed by users which shouldn't have the ability to (recent in house app. upgrade done) I'm only alerted by which process is being kill but not the context.
If there a way in profiler to log all the kill commands and the process information that is being killed?
Thanks.
August 13, 2008 at 12:41 pm
You should be able to get the spid and hostname for a kill using the ErrorLog class; filter on something like 'killed'.
August 13, 2008 at 12:44 pm
I have the user and the process ID. Just no the information about what was actual killed.
August 13, 2008 at 12:56 pm
So for example, if SPID 55 is killed by SPID 80 then you want to know what SPID 55 was doing?
How about starting with the replay trace template?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply