Is there away to capture the hostname OR IP?

• WarrenDar2

  SSC Veteran

  Points: 286

  More actions

  February 17, 2009 at 2:20 pm

  #126482

  Hello, I want to periodically (every 15 mins or so) capture hostname OR IP counter of the calling host/IP in Windows Performance Monitor, but i don't see that object/counter? Is that possible?

  The closest thing comes to mind is the SQL build-in "Activity Monitor" tool, but I don;t see an option in SQL Profile to allow me to can take a snapshot every 15 mins.

  Thanks.

• 4DJ****

  SSC Enthusiast

  Points: 124

  More actions

  February 17, 2009 at 2:41 pm

  #945528

  the best bet is to dump sys.processes output in some table and process is for your needs.

  the column that will be helpful is "hostname"

  similarly traces can be used for the same purpose.