Developer Forum

I am in the conceptual stage of a solution that should implement performance
monitoring, threshold alerts, and possibly security alerts for a SQL Server
2005 based application. Metrics such as duration of specific stored
procedures, CPU and I/O utilization, errors, etc. are to be collected by an
SNMP agent for analysis in CA Unicenter TNG. My understanding is that the
SNMP agent for SQL Server can capture some basic metrics, and I can also
gather additional metrics from sources such as Performance Monitor or SQL
Server Profiler and then pass the metrics to the SNMP agent via and API
framework.
If anyone has experience with SNMP monitoring, or Unicenter TNG
specifically, I would like to hear your general advice, opinions on the
producs, and links to good reference material.

Hi Eric

I can't say that I have ever used monitoring at the stored procedure level,
but most of these applications such as MOM etc can provide notifications when
errors are written to either a specific txt/log file, the SQL Server Error
log or the Windows Event Log. SQL Server has means to do either of these,
such as using the RAISERROR statement.

I don't think you have to treat SQL Servers perfmon counters any different
to other counters (apart from making sure they are there!).

John