Advanced SQL monitoring

videotech

I am really interested to know if APM V2 can monitor SQL stats like:

Active Transactions

Data File size

Log cache hit ratio

Log files used size

Log growths

Log shrinks

Transaction per second 

Active Transactions 

Cache hit ratio

Buffer Cache hit ratio 

SQL Cache memory used 

Number of deadlocks per second 

I am comparing APM to Opmanager, as I know Opmanager has over 50 specifc SQL Monitors which cover :

Buffer Monitors

Cache Monitors

Database monitoring

General Monitors 

Locks relateed monitors

Memory Monitors 

I believe these can be monitored via SNMP or WMI. So can APM V2 do this?

 

Thanks 

mdiotte

If you have not tried this already, try forcing a refresh of the WMI classes on the target server being queried. Use the following command within a "cmd.exe" prompt.

Windows 2000: winmgmt /resyncperf
Windows XP, 2003, Vista: wmiadap.exe /f