Post reply

How i discover the origin (ip of the host) of a process?

  • July 4, 2008 at 11:14 am

    #123073

    Hello!

    In Active Monitor of my server, i see the host name only, but i need discover the ip address.

    I try ping the host name, but i recevied that "Ping request could not find host"...

    And, how i block all process of a host? Because this host is doing heavy requisitions, so the other requests are slow, veeery slow.

    When i killing the process in Active Monitor, the others request are normal.

    Tanks

  • July 5, 2008 at 7:18 am

    #838495

    use "Ping Hostname" and see if you can Figure out the IP Address: then

    "ping -a IPAddress"

    or "Ping -t IPAddress"

    or do a "route print"

    :to go to the DNS and the forward and reverse lookup of the user name and IP address

    Maninder
    www.dbanation.com

  • July 5, 2008 at 10:35 am

    #838520

    If you query the dmv sys.dm_exec_connections, you will see the ip address.

    I don't know of any way to lock someone out by IP. If they are using a specific username, you could deny them access to the DB. From the hostname, can you identify the person who's doing this? If might be useful to have a face-to-face chat and find out what they are doing.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 8, 2008 at 7:47 am

    #839493

    So, "select * from sys.dm_exec_connections", although not related the executed query with the id connection, but identified all ips.

    The hostname that i looking was a report (Crystal Reports),because this that i could not ping. :pinch:

    Thank you for the help and care of you!

Viewing 4 posts - 1 through 3 (of 3 total)

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