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.
Author |
Topic |
noneil277
Starting Member
13 Posts |
Posted - 2009-07-24 : 10:24:27
|
Found this tool to be useful at timesSQL Server Health and History Tool (SQLH2)http://www.microsoft.com/DOWNLOADS/details.aspx?FamilyID=eedd10d6-75f7-4763-86de-d2347b8b5f89&displaylang=enSQLH2 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 service4. Performance Counters (optional) – Used to determine performance trends--Nicholas O'NeilSenior Engineer, Logicworks.netMCSA/MCSE/+Messaging/MCTS:SQL2005 |
|
|
|
|