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 ?