Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
Rajkumar Karuppiah
Rajkumar Karuppiah
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
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
MarkusB
MarkusB
SSCertifiable
SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)

Group: General Forum Members
Points: 5367 Visits: 4208
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
Rajkumar Karuppiah
Rajkumar Karuppiah
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
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.
MarkusB
MarkusB
SSCertifiable
SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)

Group: General Forum Members
Points: 5367 Visits: 4208
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
Rajkumar Karuppiah
Rajkumar Karuppiah
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
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.
Rajkumar Karuppiah
Rajkumar Karuppiah
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 47
I see the Perfmon files \SQLH2\PerfCollector\Data folder. It is not getting populated into the H2 tool

Thanks
Raj
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search