Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Performance counters on Windows server 2003 Expand / Collapse
Author
Message
Posted Wednesday, September 17, 2008 4:34 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, May 04, 2012 2:41 AM
Points: 56, Visits: 220
Hi,

At my place of employment we have a SQL 2005 installation thats running on Windows Server 2003. I set up performance counters in the past using the Performance Monitor tool to gauge how the server box was performing. I noticed recently that those counters don't exist any more on the server. Perfmon just shows numeric performance objects like 1150 and numeric counters like 1152. Is the perfmon library corrupt? How can i get the real objects and counters to show again so that i can gauge performance again.

Please help.

Tendayi
Post #570887
Posted Wednesday, September 17, 2008 9:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 29, 2012 4:02 AM
Points: 9, Visits: 98
Hi,
You can try the following command : lodctr.exe /r
It should restore the names instead of numbers...
Post #571123
Posted Thursday, September 18, 2008 12:21 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, May 04, 2012 2:41 AM
Points: 56, Visits: 220
Thanks very much. The command worked.
Post #571505
Posted Thursday, September 18, 2008 4:44 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 3:01 AM
Points: 550, Visits: 1,041

I've tried "lodctr.exe /r" on Windows 2003 which is running on a VM.
It was succesfull, but now for some reason NONE of my counters is showing up....
I get a message "Unable to Connect machine" - this is for all my other servers as well....
Could the command "lodctr.exe /r" have any influance on the VM and if so - what can i do to get my counters back?
I ran this because my sql counters were all missing.

please help!
(oh- and sorry for stealing thread)
Post #571623
Posted Tuesday, June 18, 2013 8:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 28, 2014 5:50 PM
Points: 1, Visits: 57
Once this command is executed, restart the remote registry service.
I did this on production machine in a cluster without incident.
Post #1464711
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse