Trouble running SQLH2

• philcart

  SSC-Forever

  Points: 47796

  More actions

  February 21, 2007 at 3:16 pm

  #691039

  I had a file or two hanging around as well. Couldn't work out what the problem was. Then after a reboot to apply so Windows Updates they went away.

   

  --------------------
  Colt 45 - the original point and click interface

• BC-394365

  SSC Enthusiast

  Points: 168

  More actions

  February 22, 2007 at 8:56 am

  #691189

  I deleted the old files that did not import then...

  I noticed some errors in the event log related to SQLH2, some perf counter were not available etc. I worked on removing all the errors that Perf Collector was generating. After doing this I noticed the import worked every time. I just have to keep an eye on it.

• J. Kool

  Newbie

  Points: 3

  More actions

  August 22, 2007 at 9:35 am

  #728606

  fixing the security on the repository database did the trick for me. somehow the bcp process hung as called from the SQLh2 process. I made the user running SQLh2 owner of the repository database, and suddenly things started working. I can upload any file from any server into the DB now. (i made the 'mistake' to install the perf collector on every sql box) i just removed the sqlperf from all the servers but the management server, and let the management server grab the perf counters from the hosts instead now. after i fixed the db permissions, i could copy the files from the hosts to the monitoring server and upload them into the db there.

  good stuf..

   

   

• Rajkumar Karuppiah

  Valued Member

  Points: 65

  More actions

  October 9, 2007 at 11:06 am

  #740456

  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

• cpednekar

  SSC Enthusiast

  Points: 172

  More actions

  March 26, 2008 at 10:40 am

  #794204

  Hi Guys,

  I need urgent help....

  Can you please let me know the syntax to upload the only pfc files. As, when I run sqlh2 /C"D:\SQLH2\H2Config.xml" /DDMY /dR - it performs WMI collection etc. I want to ignore this collection part and just need to upload pfc files.

  We have SQLH2 service running to collect performance data, but I also want to upload pfc files every 15mins in SQL server.

  Regards,

  Chetan

• jelongpark

  SSC Enthusiast

  Points: 135

  More actions

  December 8, 2009 at 2:51 pm

  #1089540

  I've met the same error "Network path was not found" in SQLH2 log.

  In my case it's fixed by starting Remote registry service in the target server.

  Try that.