"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.
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...
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.
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.
Article: Microsoft SQL Server Health and History Tool
Posted - 08/16/2004 : 10:39:15
