November 10, 2008 at 5:36 pm
Hi,
I am trying to tweak SCOM SQL management packs and am looking for some way to be Alerted through SCOM alerts on Number of Deadlocks/sec and Buffer Cache Hit Ratio.
I see that there is a Monitor for SQL 2000 DB Engine called Number of Deadlocks, but I don’t see one for SQL 2005 DB Engine.
As for the Buffer Cache Ratio I only see the rules called "Collect Buffer Cache Ratio" for both SQL 2005 Db engine and SQL 2000 Db engine. As I understand this is for collecting and not monitoring. Can these rules be modified to send alerts as opposed to just collect?
I am also looking for Lock Timeouts/sec, SQL Re-Compilations/sec, and SQL Compilations/sec
Sorry if this is not the right place to post.
Please help
Thank you
G.
November 27, 2008 at 10:47 pm
Yes, they're all under the SQL Server 2005 DB Engine rules, not monitors.
I'm not sure you can create an alert from a performance collection rule. According to the official MS Authoring Guide, the way to do this is to create a unit monitor that generates an alert when a defined threshold is passed. I am still struggling to get this configured correctly :unsure:
You might want to check out Grant Fritchey's[/url] and Marios Philippopoulos's [/url]articles (and the discussion) for more information.
Best Regards
Kaz
January 26, 2009 at 11:52 am
If there's a perf counter for what you need to monitor you can create Windows Performance Counter monitor, and pick static threshold and go from there.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply