SQL Server Performance

Running PerfMon remotely

Discussion in 'Performance Tuning for Hardware Configurations' started by photura, Mar 24, 2006.

  1. photura New Member

    Hello.

    Can someone give me advice on how to run Perfmon from a remote computer? Our SQL Servers are all located in a remote data center.

    Thanks.
  2. Twan New Member

    Hi ya,<br /><br />start perfmon<br />add the server's counters<br />watch them<br /><br /><img src='/community/emoticons/emotion-5.gif' alt=';-)' /><br /><br />This will only work if you have the rights on the target server, and if there is no firewall in between you and the server, or you have the right ports open on the firewall... not sure what they are off hand but I'd say the usual baddies, 135, 139, and 1024-65k?<br /><br />Cheers<br />Twan<br /><br />
  3. joechang New Member

    just to elaborate slightly on twan,
    when you Add Counters, the top pair of radio buttons is for selecting 1) the local computer, 2) a computer, ie, a remote computer,
    i believe the format is: \name
    i recall the remote registry service is required on the target computer?
  4. satya Moderator

    From Windows 2000 onwards you can schedule the PERFMON trace to collec the stats.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page