Results 1 to 2 of 2

Thread: Incorrect hostname in sysprocesses

  1. #1
    Ed Hon Guest

    Incorrect hostname in sysprocesses

    On SQL Server 6.5, we tried to track down the owner of a process,which was hogging the CPU. Using Currently Activity Detail, we went to the hostname that seemed to be the culprit, but the users had not accessed SQL Server in a few days. Where is SQL Server get the hostname from? We are on an NT4.0 network, using DHCP.

  2. #2
    Ray Miao Guest

    Incorrect hostname in sysprocesses (reply)

    Kill those dead connections, or they'll kill sql.


    ------------
    Ed Hon at 6/27/00 10:02:10 AM

    On SQL Server 6.5, we tried to track down the owner of a process,which was hogging the CPU. Using Currently Activity Detail, we went to the hostname that seemed to be the culprit, but the users had not accessed SQL Server in a few days. Where is SQL Server get the hostname from? We are on an NT4.0 network, using DHCP.

Posting Permissions

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