In my previous post, I talked about how implement the counters in Windows 2003. However I went about getting the list of counters from PAL the long way. Kind of feel a bit stupid about this now, but Clint (PAL Creator), pointed out we can do this directly in the tool. I had looked around for it in few locations, expect the obvious.
- Open PAL.
- Go to Threshold File.
- Click Export to Perfmon Template File.
- Click OK in SQL Instance Dialog Box.
- Change the Save as Type to “Logman Files (*.txt)”.
- No more manual hacking and slashing. (Thanks Clint).