SQLServerCentral / Discuss Content Posted by Kathi Kellenberger / Article Discussions / Article Discussions by Author / SQLH2: The Free Health, History and Performance Monitoring Tool / Latest Posts

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

gm.jones — Fri, 18 Feb 2011 08:06:26 GMT

This may have been covered already, but we encountered a problem with the scheduled task not collecting data. First you will need to select the option to execute the task with highest priviledges. Then create a batch file that runs the SQLH2.exe file.

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

jbucalo48 — Wed, 27 Jan 2010 09:39:10 GMT

Your article is very good, one of the best I have found on the web. I am very new to SQL Server, reporting services, .NET etc and am on the steep edge of the learning curve. I have inherited a server running SQL Server 2005 and I am trying to get SQLH2 to work. Reporting services is running as I can create reports using .NET, but what I can not do, in the ReportV2.cab section, is"create a data source pointing to the Repository database and upload each report"Most probably, reporting services is not properly configured, but try as I might, I can not execute this step. If you could give me a few pointers it would truly help. Thanks

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

ravikanth. — Tue, 26 Jan 2010 07:51:11 GMT

Does SQLH2 supports SQL Server 2008??..Why does it doesn`t work on Clusters?.

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

Kathi Kellenberger — Tue, 19 Jan 2010 19:31:19 GMT

Shoot an email to SQLH2@Microsoft.com if you don't find the answer.

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

rob 12143 — Tue, 19 Jan 2010 18:32:28 GMT

Thanks Kathi,I will search else where.Rob

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

Kathi Kellenberger — Tue, 19 Jan 2010 14:43:38 GMT

I am no longer using this product, so I don't know your answer. Microsoft was pretty good about answering questions about it, so you might take a look at the documentation for a contact email.

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

rob 12143 — Tue, 19 Jan 2010 09:50:37 GMT

Hi,I'm new to this forum.Does the SQLH2 solution also record SQL Agent Job stats.I need a solution that monitors a large ETL BI warehouse jobs.ThanksRob

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

YSLGuru — Mon, 30 Jun 2008 13:29:46 GMT

I've hit a roadblock that I'm hoping someone hgas some ideas on.I'm versed in SQL Server's core DB product/service but am very new amd green with regards to Reporting Services. I installed this tool and followed the instructions to the letter, differening only where appopriate such as serviname, ect. When I get to the step where I add a Data Source I get the below err msg when clicking OKK to create the new data source:[quote]The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) Get Online Help The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) Bad Data. (Exception from HRESULT: 0x80090005) [/quote]I looked this up and found a posting about Backup/Restore/Change & Delete of an Encryption key. I am however uncertain about any of these, about performing any action as nothing about this was listed in the Comprehensive Install Guide which I used for the install/Setup of the Health tool.There are a few other SSRS based reports on this same server/instance which are in live use and so I must be careful what I do about my own error so as to not break anyone else's existing reports. Is there any way to reset this to it's state prior to installing the SQLH2 tool? It looks like the encryption on this is optional. Is there any way to remove it entirely without loosing any existing reports? If it is discovered later that a consultant (or whomever added these other reports in use) has them set up wioth encryption can that encryption be added back? I'm trying to find a way to get this all working even if it means stripping out encryption and then putting it bacl.What is PRIORITY is to not loose/break/destroy the ther reports on the same insktance of SSRS.Thanks in adavance!HELP??

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

dgray1 — Fri, 20 Jun 2008 08:29:34 GMT

This may be too late for you now, but I had this problem as well. It was due to the fact that the Sybase client was on the server where sqlh2.exe ran & the sybase client was in the PATH enviornment variable before the MS SQLServer. You can check this by running bcp /v from the command line. If its sybase, try moving the path to the client to the end of the PATH variable.CheersDan

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

jroselln — Fri, 11 Apr 2008 06:09:17 GMT

What does -3 state means on a PerfColector?I'm using en-US windows locale spanish sql server & database with english in user instance settings. That's the SQLH2 log: 4/11/2008 1:40:44 PM Status: Starting Perf Loader4/11/2008 1:40:44 PM INFO: Perf host_id = 24/11/2008 1:40:44 PM INFO: Lock aquired: pid = 14/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pf040108165200.txt:fid = 1, state = -3, retry = 04/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc040108173252.txt: fid = 3, state = -3, retry = 04/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc040308121908.txt: fid = 4, state = -3, retry = 04/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc040908030916.txt: fid = 5, state = -3, retry = 04/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008103549.txt: fid = 6, state = -3, retry = 04/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008113250.txt: fid = 7, state = -3, retry = 04/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008130242.txt: fid = 8, state = -3, retry = 04/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008160816.txt: fid = 9, state = -3, retry = 04/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008163638.txt: fid = 10, state = -3, retry = 04/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008165536.txt: fid = 11, state = -3, retry = 04/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008175623.txt: fid = 12, state = -3, retry = 04/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008180152.txt: fid = 13, state = -3, retry = 04/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008180943.txt: fid = 14, state = -3, retry = 04/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008190030.txt: fid = 15, state = -3, retry = 04/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008190043.txt: fid = 16, state = -3, retry = 04/11/2008 1:40:44 PM INFO: Lock released: pid = 14/11/2008 1:40:44 PM Status: Perf Loader finished That's C:\SQLH2\PerfCollector\Data\pf040108165200.txt file: e2e15752-d140-4ca8-8d1f-9fbd8dc6c44f,632dfe80-4808-4f2b-aa06-673456abcb02,e25ef2c6-160c-44a5-99c7-9fedd1ef50b3,, ,,,,1,SRVPRUEBAS,,, ,,,, ,,,,1,PROCESSOR,% PROCESSOR TIME,_TOTAL,2,PROCESSOR,% PRIVILEGED TIME,_TOTAL,3,MEMORY,AVAILABLE KBYTES,,4,MEMORY,PAGES/SEC,,5,MEMORY,COMMITTED BYTES,,6,MEMORY,COMMIT LIMIT,,7,SYSTEM,PROCESSOR QUEUE LENGTH,,8,SYSTEM,CONTEXT SWITCHES/SEC,,9,PHYSICALDISK,AVG. DISK QUEUE LENGTH,_TOTAL,10,PHYSICALDISK,AVG. DISK SEC/READ,_TOTAL,11,PHYSICALDISK,AVG. DISK SEC/WRITE,_TOTAL,12,PHYSICALDISK,DISK READS/SEC,_TOTAL,13,PHYSICALDISK,DISK WRITES/SEC,_TOTAL,14,PHYSICALDISK,DISK READ BYTES/SEC,_TOTAL,15,PHYSICALDISK,DISK WRITE BYTES/SEC,_TOTAL,16,PROCESS,% PROCESSOR TIME,SQLSERVR,17,SQLSERVER:BUFFER MANAGER,BUFFER CACHE HIT RATIO,,18,SQLSERVER:BUFFER MANAGER,CHECKPOINT PAGES/SEC,,19,SQLSERVER:BUFFER MANAGER,PAGE LIFE EXPECTANCY,,20,SQLSERVER:MEMORY MANAGER,TOTAL SERVER MEMORY (KB),,21,SQLSERVER:MEMORY MANAGER,TARG

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

Kathi Kellenberger — Tue, 04 Apr 2006 12:39:00 GMT

Thanks!

I just found out from Microsoft that this version does support SQL Server 2000. They said that a previous version worked with SQL 2005 beta and this version was updated for the released version. So, it is the correct download.

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

Ranga N — Tue, 04 Apr 2006 08:05:00 GMT

Kathi,

Very good article....

I saw on the microsoft site and it says "This version(2.027) of SQLH2 supports SQL Server 2005 RTM collection "

Is there a different version of SQLH2 for SQL 2000 ?

Thanks,

Ranga

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

Kathi Kellenberger — Wed, 30 Mar 2005 15:03:00 GMT

When I gave this presentation to the local user group, this question came up. The only idea someone had was for the performance files. Use the performance collector in each domain. Then, collect the files into the performance data folder where the repository database is installed. I haven't tried this, so I don't know if it will work. I can email the person who wanted to do this and see if he had any luck. You can also send an email to SQLH2@Microsoft.com with questions.

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

Norman Kelm — Wed, 30 Mar 2005 14:55:00 GMT

Any way to make this work across NON-trusted domains? Other than installing it in every domain. Centralized collection would be nice.

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

Kathi Kellenberger — Wed, 30 Mar 2005 10:56:00 GMT

That is very odd, the SQLH2 base collector is only supposed to pick up files starting with 'pfc', so it shouldn't have even tried to open that file. Normally, you don't stop the performance collector at all to run the base collector, so, in theory you shouldn't have a problem. Running the base collector in between the stop and start evidently works for you, so continue on...

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

gregfaulk — Wed, 30 Mar 2005 09:14:00 GMT

I experienced the same problem as Nikolay Chernavsky. I had to stop the service, then run SQLH2.exe, then start the service in order to avoid the file lock issue.

Below is the error I received when the bat file command order was start service, stop service, run SQLH2.exe:

3/30/2005 7:50:48 AM INFO: D:\SQLH2\PerfCollector\Data\pf033005011842.txt: fid = 7, state = 0, retry = 0

3/30/2005 7:50:48 AM ERROR: The process cannot access the file "D:\SQLH2\PerfCollector\Data\pf033005011842.txt" because it is being used by another process.

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

Kathi Kellenberger — Tue, 29 Mar 2005 12:00:00 GMT

It will still work if you just stop and start the service. When the service is restarted, it will create a new file with a different name. The old file will not be locked.

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

Nikolay Chernavsky — Tue, 29 Mar 2005 11:55:00 GMT

Kathy,

I think there is an error in batch file. I believe it should look like

NET STOP SQLH2PerfCollectorC:\SQLH2\SQLH2.exe /CC:\SQLH2\H2ConfigPerf.xml NET START SQLH2PerfCollectorOtherwise performance file is locked by the service and SQLH2 can not get anything out of it.

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

Kathi Kellenberger — Mon, 28 Mar 2005 08:33:00 GMT

SQL Server Central is all about DBAs and developers helping each other out, so I'm sure that others would appreciate learning about these tools as well. Thanks for mentioning them!

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

chisholmd — Mon, 28 Mar 2005 08:25:00 GMT

I setup this tool but I was after more frequent collection of performance counters for overall sytem health (System, ASP, etc). I think I set it for hourly collection and the database quickly grew to large. Not to knock this tool but for my purposes I have opted to use the round robin database http://www.rrdtool.org. Adrian Wood put together a complete package for system monitoring including an ASP front end called wshRRD which is available at http://members.optusnet.com.au/~picuspickings/There is also a java version of this solution called JRobin (http://www.jrobin.org/) but I havn't tried it yet.The set up is probably as involved as SQLH2 but the nature of RRD means that the database size is fixed. In my case the the db size for each performance counter (each instance) is 41kb and will never get bigger! It has a built in graphing function. So now I collect performance counters every 10 minutes without having to worrey about it consuming my harddrive.Cheers,

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

Kathi Kellenberger — Mon, 28 Mar 2005 07:58:00 GMT

Thanks, Brian. I found the the set up was a little tricky at first, too. My goal was to give a different perspective on installing and configuring so that others would have an easier time than I did. I also think that this tool is not widely known and many DBA's might hear about it from my article.

RE: SQLH2: The Free Health, History and Performance Monitoring Tool

Brian Knight — Mon, 28 Mar 2005 04:59:00 GMT

Kathi, good article. I love this tool and it's price tag especially . The setup though was a bit of a challenge and maintainability is tricky (modifying the XML files, etc). It's a great version 1 product though overall and I'm sure they'll build on it.

SQLH2: The Free Health, History and Performance Monitoring Tool

Kathi Kellenberger — Thu, 17 Mar 2005 16:16:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/kKellenberger/sqlh2thefreehealthhistoryandperformancemonitoringt.asp