SCOM 2007 and SQL 2000 and 2005 Management packs

  • 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.

  • 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

  • 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