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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » SQL H2 -- Couldn't find required registry key...

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

Rate Topic

Display Mode

Topic Options

Author

Message

Rajkumar Karuppiah

Posted Tuesday, October 09, 2007 11:03 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 17, 2012 7:51 AM
Points: 5, Visits: 47

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

Post #408596

MarkusB

Posted Thursday, October 11, 2007 2:51 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:35 AM
Points: 4,226, Visits: 3,887

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

Markus Bohse

Post #409397

Rajkumar Karuppiah

Posted Thursday, October 11, 2007 8:13 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 17, 2012 7:51 AM
Points: 5, Visits: 47

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.

Post #409546

MarkusB

Posted Thursday, October 11, 2007 8:58 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:35 AM
Points: 4,226, Visits: 3,887

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

Markus Bohse

Post #409575

Rajkumar Karuppiah

Posted Friday, October 12, 2007 8:43 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 17, 2012 7:51 AM
Points: 5, Visits: 47

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.

Post #410022

Rajkumar Karuppiah

Posted Thursday, June 12, 2008 5:47 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 17, 2012 7:51 AM
Points: 5, Visits: 47

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

Thanks
Raj

Post #515808

« Prev Topic | Next Topic »

Permissions