Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2004
    Posts
    660

    Unanswered: Question about Process Info

    Hello, i just check the process Info in the sql server enterprise manager, I found two same user but different host (such as host1 and host2), and also i have update problem that write confilct error messager (i use access as front end and sql server as back end)
    Does the two process cause problem? Actually i found the host2 computer actually is dead, why that host appear in the process Info, any body has idea? Thanks in advance.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    It's a ghost connection. The client died for whatever reason, but failed to notify the server that no results are needed. The server continues to process the request. Normally this situation is also associated with open transactions that are left behind uncommitted. The same user simply means that both users connected to the server with the same standard security context.
    Last edited by rdjabarov; 07-27-04 at 14:43.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Mar 2004
    Posts
    660
    rdjabarov, actually the one dead host is administrator's comptuer. How can i handle this, try to notify the server, actually i found this host also use lot message, and also it has login time, is that possible?

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    What do you mean "lot message"? System table (sysprocesses) would display login info, that's why I am saying that the server "thinks" the connection is still alive. The only thing that is left to do is to kill the spid.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    Mar 2004
    Posts
    660
    sorry, i mean it use lot memory. So if i kill the spid today, it won't show up later, is that right?

  6. #6
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    That's right, the same exact process will never show up again...but a different one originated by the same user from the same host may and probably will.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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