Post reply

Processes, locks

  • March 4, 2008 at 2:16 am

    #187475

    When I look into the current activity on my sql 2000 server I see some very old processes running, how can I delete / remove these processes ?

    If I right click on the process and select 'kill process' nothing happens ?

    I'm a real sql newbie so explain easily for me please 😉

  • March 4, 2008 at 9:09 am

    #785014

    Can you restart the SQL services? This will flush out unneeded logins and give you a clean look at who connects and to what. What are you currently using to get the user information? Why does it seem out of the ordinary? I see logins that look like they haven't done anything in some time but are actually running the services and connecting to master or msdb, with a last batch date equal to the last service reboot. You don't want to kill those jobs. Execute sp_who2 (from QA) to see who the login is, where they are connecting from (host name), what it is they're executing (command) and what application they are connecting with (program name). This will give you a better picture as to what the users are doing and allow you to make better decisions before you act.

    -- You can't be late until you show up.

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

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