Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    CT
    Posts
    8

    Question Unanswered: MS SQL Server - sleeping processes that reawaken

    We are runnoing SQL server enterprise manager on a Win2K box. In the Process Info view, there are several processes that are in a "sleeping" state whose hostname references a machine that is no longer on our network.

    When I try to kill the process, it does go away (verified by both the "Current SQL Server Log" and in the Evenet Manager), but a few minutes later, the process reappears with the same PID and Hostname.

    Does anyone know why this might occur?

    Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    Mumbai, India
    Posts
    36
    The records are existing in your master..sysprocesses. Killing those SPID's would suffice. In case it is coming back, maybe somebody has changed his machine name to that machine name as that machine no longer exists. And then he is accessing your SQL Server.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •