Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: Microsoft SQL Server Health and History Tool
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ask SQLTeam Question

0 Posts

Posted - 08/16/2004 :  10:39:15  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
"The Microsoft SQL Server Health and History Tool is designed to allow you to collect information from instances of SQL Server, store this information, and run reports against the data in order to determine how SQL Server is being used." It appears to capture configuration data and store it on a regular basis. The Deployment Guide has more information.

Article Link.

Yak Posting Veteran

53 Posts

Posted - 08/17/2004 :  05:23:14  Show Profile  Reply with Quote
Has anyone actually got this tool to work? It has failed on all servers I've tried on. Either with strange "incorrect syntax near 'd'" errors or "out-of-range error when converting char to datetime"...

Looks like a good tool though if you could get it to work...
Go to Top of Page

Flowing Fount of Yak Knowledge

3575 Posts

Posted - 08/18/2004 :  01:21:22  Show Profile  Reply with Quote
it doesn't work with a cluster though. useless to me, since everything we have is clustered.

Go to Top of Page

Starting Member

4 Posts

Posted - 10/05/2004 :  16:57:29  Show Profile  Reply with Quote
When I tried to schedule a task for the SQL H2 collector I got the error message " The system cannot find the file specified" I have the latest .net installed. I skipped that step. Then when i try to get data I get the error "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value." I have uninstalled this product as it appears to be useless. Maybe in the future it will actually work.
Go to Top of Page

Starting Member

2 Posts

Posted - 04/08/2008 :  00:53:05  Show Profile  Reply with Quote

I have configured this in my servers, the tools seems to be very good one, but u require some tweeking here and there. otherwise you can use this tool in lot of ways.


Thanks & Regards

Vijai Krishnaraj
Go to Top of Page

Starting Member

7 Posts

Posted - 06/27/2008 :  12:55:37  Show Profile  Reply with Quote
Hi Vijai,

Do you have your SQLH2 running as a job each night? I can't get mine working properly, as it doesn't see the H2Config.xml file.

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 1.31 seconds. Powered By: Snitz Forums 2000