SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQLH2: The Free Health, History and Performance Monitoring Tool


SQLH2: The Free Health, History and Performance Monitoring Tool

Author
Message
Kathi Kellenberger
Kathi Kellenberger
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1177 Visits: 342
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/kKellenberger/sqlh2thefreehealthhistoryandperformancemonitoringt.asp

Aunt Kathi
Linchpin People Teammate
SQL Server MVP
Author of Expert T-SQL Window Functions
Brian Knight
Brian Knight
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: Moderators
Points: 2589 Visits: 235
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.

Brian Knight
Free SQL Server Training Webinars
Kathi Kellenberger
Kathi Kellenberger
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1177 Visits: 342
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.

Aunt Kathi
Linchpin People Teammate
SQL Server MVP
Author of Expert T-SQL Window Functions
chisholmd
chisholmd
SSC Veteran
SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)

Group: General Forum Members
Points: 266 Visits: 86
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,

Dave

Trainmark.com IT Training B2B Marketplace
(Jobs for IT Instructors)
Kathi Kellenberger
Kathi Kellenberger
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1177 Visits: 342
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!

Aunt Kathi
Linchpin People Teammate
SQL Server MVP
Author of Expert T-SQL Window Functions
Nikolay Chernavsky
Nikolay Chernavsky
SSC-Enthusiastic
SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)

Group: General Forum Members
Points: 135 Visits: 32

Kathy,

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

NET STOP SQLH2PerfCollector
C:\SQLH2\SQLH2.exe /CC:\SQLH2\H2ConfigPerf.xml
NET START SQLH2PerfCollector

Otherwise performance file is locked by the service and SQLH2 can not get anything out of it.


Kathi Kellenberger
Kathi Kellenberger
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1177 Visits: 342

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.



Aunt Kathi
Linchpin People Teammate
SQL Server MVP
Author of Expert T-SQL Window Functions
gregfaulk
gregfaulk
SSC Journeyman
SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)

Group: General Forum Members
Points: 95 Visits: 45

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.





Kathi Kellenberger
Kathi Kellenberger
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1177 Visits: 342
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...

Aunt Kathi
Linchpin People Teammate
SQL Server MVP
Author of Expert T-SQL Window Functions
Norman Kelm
Norman Kelm
SSC-Enthusiastic
SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)

Group: General Forum Members
Points: 194 Visits: 325
Any way to make this work across NON-trusted domains? Other than installing it in every domain. Centralized collection would be nice.



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