Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Problem: I have a production server ( 64-bit Windows server 2003 R2 ), when i try to add Sql:Databases counter in the perfmon, it does not show me the recently added databases to select from.

Addition Info: Now i had the same problem on another server which is my standby server. In this case i re-build the perfmon counters and restarted the sql service and the database listing in perfmon was refreshed and correct.

But the server in question is production box and i cannot re-start the sql service on it. Any ideas ?

share|improve this question

Are you sure you have the latest service packs, etc? I just tried this on one of our servers (Windows 2003 R2, x32, SQL Server Express 2005 latest) and it worked fine.

Otherwise, try (from the command line):

wmiadap /clearadap
wmiadap /resyncperf
wmiadap /f
net stop winmgmt
net start winmgmt
share|improve this answer

Are you capturing the Perfmon data to CSV files?

If so then you can't add new objects on the fly.

share|improve this answer

Your Answer


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