Solved

Repair performance counters

Posted on 2009-07-13
11
624 Views
Last Modified: 2012-05-07
Keep losing the SQL counter categories for perfoamnce monitor on a Win 2.3k server.
This upsets a program I have them monitors them from my workstation.
How can I resolve this. I have googled and run Lodctr /r:PerfStringBackup,ini as suggested at MS.
Restarting SQL has no effect.
0
Comment
Question by:QPR
  • 4
  • 2
  • 2
  • +2
11 Comments
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 24848006
Usualy you need to restart server and not only SQL service.
It's a stand-alone or cluster?
0
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 24849242
<<Keep losing the SQL counter categories for perfoamnce monitor on a Win 2.3k server.>>
Could you describe more precisely what you mean by *loosing the SQL counters*...Do you mean they don't appear in the choices of counters?  Does that happen always? sometimes? How are collecting these counters ? remotely? locally? is there a firewall between the server and  the perfmon client?  How do you collect? IP? DNS?
0
 
LVL 51

Accepted Solution

by:
Mark Wills earned 500 total points
ID: 24851606
You do not mention which version of SQL you are running....

for example,

if running SQL 2008 : http://support.microsoft.com/kb/969653/en-us
if running SQL 2000 : http://support.microsoft.com/kb/812915/en-us

To check the INI file and determine which sqlctr.ini file to load : http://blogs.msdn.com/john_daskalakis/archive/2009/05/07/9593110.aspx

In windows server you can rebuild / reload the counters : http://support.microsoft.com/default.aspx?scid=kb;en-us;Q300956

Now, you have to make sure you get the right ini file and must not have any perfmon running, and then restart SQL (could even require a reboot).
0
 
LVL 29

Author Comment

by:QPR
ID: 24853585
to answer some of the above.
It is sql 2000, a server reboot will bring them back but they soon disappear.
They are the built in SQL objects and their associated counters.
No firewall between, they ar missing regardless of where I look... remotely or when sitting at the server keyboard. Standalone server/sql no cluster
Mark: will look through the rebuild url when back at work tomorrow
0
 
LVL 51

Expert Comment

by:Mark Wills
ID: 25039271
angelIII,

Is there any reason why ID:24851606 is unacceptable to you ? There is the rebuild and all the details about performance counters...
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 25046822
mark,

 when it comes to performance counters, many things can go wrong...
 so while your suggestion is definitively worth a try and most likely to fix the issue, it's not for sure,
 unfortunately the asker did not come back to confirm ....

 I won't object a "accept" or "PAQ", though.

regards, a3

 
0
 
LVL 51

Expert Comment

by:Mark Wills
ID: 25047621
Thanks angelIII for getting back.

I do agree - performance counters can be a mine-field - and I was prepared for the possibility of an ongoing discussion. When the asker did not come back my initial reaction was "great the rebuild worked" - which also reflected in my reaction to the CV recommendation - and was probably a bit optimistic.

I do realise that it also may not have worked, but those links are almost 90% of most problems, and so might have worth in PAQ if nothing else (well I was hoping for an "Accept").

Cheers,
Mark Wills
0
 
LVL 29

Author Comment

by:QPR
ID: 25063757
Sorry for not getting back sooner, I haven't had time to follow up any potential suggestions as other things climbed up the priority ladder at work. That said, the problem hasn't reappeared for some time.
Angellll I'm open to suggestions on how to deal with this Q now. Accept answer, multi accept, delete no refund, other?
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 25063783
QPR,

  the choice is yours, basically:
  § if 1 or more of the comments solved, or at least helped/pushed into the right direction: accept/split
  § if you found the solution yourself, accept your comment (posting your solution)
  § if you had found no solution, you would start to delete the question

angel eyes
0
 
LVL 51

Expert Comment

by:Mark Wills
ID: 25064794
QPR thanks, and please let me know if there is any recurrance (post a comment in this thread/ a new question referring to this this thread as a related question,  so we can work out what we need to do)...

angel eyes, thanks for helping this one through the process.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now