Performance logging will not start on its own at boot time. Here’s how to get around that problem.

 

Applies to: W2k3, XP

1. Using the Performance MMC, create a set of counter logs.
2. Use a specific name to save the settings, e.g., SQLPERF.
3. At the command prompt, try starting and stopping performance logging using the logman.exe utility:
   1. logman start sqlperf
   2. logman stop sqlperf
4. Set the Windows registry to automatically start performance counters at system startup
   1. Open the Registry Editor, regedit.exe.
   2. Navigate to HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Run
   3. Add a string value. A good name would be logman.
   4. Set the value equal to logman start sqlperf (or the command in step 4.a. that successfully started performance logging).

References:

1. [1] http://support.microsoft.com/kb/303133
2. [2] http://www.jsifaq.com/SF/Tips/Tip.aspx?id=4455