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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-06-05 : 08:41:15
|
| Björn writes "We make use of Tivoli as a surveilance tool. Which counters do I have to monitor in order to have some proactive information? We have SQL 6.5/7/2000Not to many though since I don want to have to many alarms from counters that reached the threshold. Things monitored today is:*Disk util*Ping*Services*Failed agent jobsThanks in advance// Björn" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-05 : 12:13:58
|
| You'll want to look at the Performance Monitor section at [url]http://www.sql-server-performance.com/[/url].Tara |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2003-06-06 : 02:03:04
|
| Are you using netview or the Tivoli Management for SQL Server tool? I think netview can only directly grab SNMP data, not the perfmon counters. I have not used their SQL Management tool however, so I do not know if it can access perfmon counters directly.I ran across a tool that works as a bridge of sorts between SNMP and the perfmon counters. It gives any SNMP management tool access to most perfmon counters. You might want to use this if the counters you want to monitor are not available via SNMP. Please note, that we used this tool briefly with MRTG a year or so ago, and at that time it worked pretty well. However, it may stop working in the future with future service packs/OS releases since it is basically an unsupported hack.Check here for details: http://www.wtcs.org/snmp4tpc/snmp4nt2.htmAs far as the specific counters to watch, check sql-server-performance.com for some good info:http://www.sql-server-performance.com/performance_monitor_tips.asphttp://www.sql-server-performance.com/performance_monitor_counters_sql_server.aspgood luck-ecEdited by - eyechart on 06/06/2003 02:17:30 |
|
|
|
|
|
|
Counters - Tivoli