Hi Kevin,
Thanks for the great post. Is there a way to combine the "Data File(s) Size (KB)" and the "Log File(s) Size (KB)" counters into one rule to get a more accurate data point for a databases size?
20 Jan 2011 8:43 PM
@cMoLe -
Not in the performance collection rule itself natively. You have two options:
1. Collect both - then architect a custom report which collects both.
2. Use a script to collect both values from WMI, do the math, then insert the information as a propertybag to a collection rule.
Option #1 might be challenging to get the right data all the time, and Option #2 will be resource intensive due to the number of DB's and scripts, and you have to be very careful with that route - not running it too frequently and learning how to make your custom script datasources support cookdown.
Apa
7 Mar 2011 6:22 PM
Kevin,
Any word about collecting DMV data?
Apa
9 Mar 2011 5:59 PM
Kevin,
Something like this:
Find Most Expensive Queries Using DMV
blog.sqlauthority.com/.../sql-server-find-most-expensive-queries-using-dmv
Generate alert is total_logical_reads exceed certain threshold.
It’s doable using SQL jobs easily.
Interesting to bring data into SCOM and correlate with something else to avoid false positives.
Daniel
31 Mar 2011 8:07 AM
Mhm this didn't work for me. Is there something like an error log? I see no counters in my performance view. I have an English SCOM Server and a German SQL Server 2005, is this a Problem? I also tried it with with the German Objectname ("Datenbanken instead of Databases") and Countername("Größe der Datendatei(en) (KB)" instead of "Data File(s) Size (KB)"), but it wont work. It would be helpful if there is something like an error log,... eventually somebody here got an idea.
Amar
6 Sep 2013 10:49 AM
I am using SCOM 2012 facing problem in performance counter monitoring, Problem is when performance counter is deleted SCOM console still shows healthy sate for that object.
Amar
6 Sep 2013 10:51 AM
I am using System.Performance.ThresholdMonitorType to monitor the performance counter.