Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

How can we start running perfmon automatically on active SQL Server active node? Typically when we failover to the inactive node and we forgot to run the perfmon. We want to start running the perfmom automatically if possible. If not how can we tell if perfmon is not running so we can send out alert to start the perfmom? We can watch the log file output but we want to know if there is more elegance solution. Thank you.

share|improve this question

1 Answer 1

The easiest way I can think of is to schedule a SQL Agent job at agent startup to start the perfmon counter on the node using logman.

http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/nt_command_logman.mspx?mfr=true

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.