January 6, 2009 at 2:45 pm
Yesterday, I set up perfmon to trace SQL performance. Today, when I started the trace, an error message was generated and the objects were missing in the list. I scoured the event log and there was no clue why they were missing....Here is an example message -
The service was unable to add the counter '\\SERVERNM\SQLServer: Databases(tempdb)\Log File(s) Size (KB)' to the 01052009 log or alert. This log or alert will continue, but data for that counter will not be collected. The error returned is: The specified object is not found on the system.
How do I rebuild or reload the SQL objects from the sqlctr.ini file for perfmon to use and why did they disappear?
The server:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Thanks for your assistance...
January 6, 2009 at 4:50 pm
Did the machine reboot? Is SQL Server running?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 7, 2009 at 8:40 am
SQL service is stopped and restarted every night at 11:00 PM so a snapshot of the datafiles can be backed up. At that time, I had an alert activated to monitor processor with a threshold. The alert is no longer active and after the SQL restart last night, the SQL object are still not available in the list. I cannot reboot the server until the next scheduled downtime 1/13/08.
January 7, 2009 at 9:05 am
Do the objects/counters show up in Perfmon if your rerun it interactively?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 7, 2009 at 9:10 am
barb.wendling (1/7/2009)
SQL service is stopped and restarted every night at 11:00 PM so a snapshot of the datafiles can be backed up....
This seems like an unusual (and possibly unreliable) approach. Is there any reason that you cannot use SQL Backups or an agent from your backup software for this?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 7, 2009 at 9:33 am
It is because the files are ~250GB and it is the fastest way. SQL backups are also performed. We are having discussions about a new platform and changes will be made in the future.
The objects are no longer visible in the selection list. I have done some research and found that they are located in the sqlctr.ini file in the Binn directory, I tried to reload them, but no luck. I was hoping they would display after the restart last night, since I stopped the alert, not there. I think I need to either apply SP4, reboot the machine, or both.
I hope this Microsoft issue was addressed in later versions.
January 7, 2009 at 9:40 am
I do not remember SQL 2000 minutia that well, but don't you have to set something at startup to get it to create it's PerfMon objects? I am wondering if your backup procedure is restarting it correctly?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply