SQL H2 -- Couldn't find required registry key on Perf Provider

Question

Post reply

SQL H2 -- Couldn't find required registry key on Perf Provider

Rajkumar Karuppiah

Valued Member

Points: 65
More actions
October 9, 2007 at 11:03 am

#70224

Need a help with SQL H2 performance counter data collection...
10/9/2007 3:00:26 AM ERROR: Couldn't find required registry key on
Perf Provider
10/9/2007 3:00:26 AM WARNING: Errors were encountered processing
PerfProviders
It is working fine on the local machine. I am getting this error with
the target server. I have added this server in the XML file but i am
getting this error.
Any help on this is greatly appreciated.
Thanks
Raj

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

It would help if you would write which performance counter is causing the problem.

From my experience the error can be caused by two things.

1. The specified counter doesn't exists on the server. For example if you want to values for Logical Disk E: and the server has no E: drive.

Or what sometimes happens with SQL counters that they are not initialized on a server. Check in System Monitor on the server if the counter in question exists.

2. There are some counters where depending on the OS (W2000 vs 2003 or XP) an extra space must be added a a certain point. I think "Target Server Memory(KB)" was such a case.

Hope this helps

Markus

[font="Verdana"]Markus Bohse[/font]

Rajkumar Karuppiah Valued Member Points: 65 More actions · Answer 2

Thanks for your response...

I have all the counters that comes default in SQL H2. It is not reading any of those counters.

When i tried the counters directly on the server i could see all the counters.

The target server has 4 GB Memory and 1.5 GB is available.

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 3

Where do you see those errors?

In the eventviewer or somewhere else.

From my experience when you start the SQLH2 Performance Collector, for each counter one or more entries show in the application log. If any counter fails an error will be recorded for that counter specifically. One failed counter will result in total failure to import data into the SQLH2Repository.

Also on where are you running the collector server? Is it on the same server as the target server or a different one.

Have you checked that all the performance counters exist in system monitor?

Do you see any files created in the SQLH2\PerfCollector\Data folder?

Have you tried to start sqlh2.exe manually?

Markus

[font="Verdana"]Markus Bohse[/font]

Rajkumar Karuppiah Valued Member Points: 65 More actions · Answer 4

Where do you see those errors?

I see this error in the SQLH2 Log file created when we run the SQLH2.exe.

From my experience when you start the SQLH2 Performance Collector, for each counter one or more entries show in the application log. If any counter fails an error will be recorded for that counter specifically. One failed counter will result in total failure to import data into the SQLH2Repository.

I am trying to collect the performance counters from a target server. It is working fine for the local server.

All the performance counters exist in system monitor.

Do you see any files created in the SQLH2\PerfCollector\Data folder?

No file in this folder but there is a txt file under D:\SQLH2\Perfmon

Have you tried to start sqlh2.exe manually? It tried only manually.

Rajkumar Karuppiah Valued Member Points: 65 More actions · Answer 5

I see the Perfmon files \SQLH2\PerfCollector\Data folder. It is not getting populated into the H2 tool

Thanks

Raj