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

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

AskSQLTeam
Ask SQLTeam Question

USA
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.

Argyle
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

eyechart
Flowing Fount of Yak Knowledge

USA
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.


-ec
Go to Top of Page

fhanlon
Starting Member

Canada
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

vijai.krishnaraj
Starting Member

India
2 Posts

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

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.

Vijai

Thanks & Regards

Vijai Krishnaraj
Go to Top of Page

sparkle
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.

Thanks,
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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 0.06 seconds. Powered By: Snitz Forums 2000