SQL Server Performance Forum – Threads Archive
Running PerfMon remotelyHello. 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.
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 />
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?
From Windows 2000 onwards you can schedule the PERFMON trace to collec the stats. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.