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

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Microsoft SQL External Tools

Author  Topic 

noneil277
Starting Member

13 Posts

Posted - 2009-07-24 : 10:24:27
Found this tool to be useful at times

SQL Server Health and History Tool (SQLH2)
http://www.microsoft.com/DOWNLOADS/details.aspx?FamilyID=eedd10d6-75f7-4763-86de-d2347b8b5f89&displaylang=en

SQLH2 collects four main types of information:
1. Feature Usage – What services/features are installed, running and level of workload on the service.
2. Configuration Settings – Machine, OS and SQL configuration settings, SQL instance and database metadata.
3. Uptime of the SQL Server service
4. Performance Counters (optional) – Used to determine performance trends



--
Nicholas O'Neil
Senior Engineer, Logicworks.net
MCSA/MCSE/+Messaging/MCTS:SQL2005
   

- Advertisement -