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

SQL H2 -- Couldn't find required registry key on Perf Provider Expand / Collapse
Author
Message
Posted Tuesday, October 9, 2007 11:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, October 11, 2007 2:51 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 5:31 AM
Points: 4,429, Visits: 4,183
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
Posted Thursday, October 11, 2007 8:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, October 11, 2007 8:58 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 5:31 AM
Points: 4,429, Visits: 4,183
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
Posted Friday, October 12, 2007 8:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, June 12, 2008 5:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse