2

I've been using PerfMon to monitor some SQL Server Stats for a while but we recently moved our production SQL Server to a different domain and I'm having trouble setting this back up. When I try to add the counters in it recognises it but then when I expand a section I get Can't Load Counters.

We have a trust between the domain and I've added my local login account to the 'Perf Monitor Users' & 'Perf Log Users' group on the destination domain.

enter image description here

Anyone had this before or got any ideas?

1

I recognize this question is old but I had to finesse an answer under slightly different circumstances. This won't address domain trust issues. Still, given the number of views, I thought this was worthy of sharing. It worked for me on a Windows 7 machine.

General

  1. Elevate a cmd.exe's privileges (Run as Administrator) so you can runas another user.
  2. From the elevated command window, open a cmd window under the desired credentials, e.g. (runas /user:<doman>\<user> cmd).
  3. From the command window with the desired credentials run mmc (NOT PerfMon directly).
    • If you don't do this I don't see how to save the changes you make.
  4. In the MMC (Console) add the Performance Monitor snap-in (File | Add/Remove Snap-in...).
  5. Now you should be able to access the desired server(s) with the desired credentials. Also you can now save your work (File | Save As...).

In Windows 7

  1. Start, type cmd (search programs and files), right-click on the resulting cmd.exe and select Run as administrator. Accept the elevated privileges prompt (User Account Control dialog).
  2. In the resulting command window (Administrator: C:\Windows\System32\Cmd.exe), enter runas /user:<domain>\<user> cmd.
  3. In the resulting command window, "cmd (running as <domain>\\<user>)", type mmc
  4. In the resulting mmc window, "Console1 - [Console Root]", chose File | Add Remove Snap-in..., select Performance Monitor.
  5. Add your counters and now you can also save them.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.