Dependency between Windows Computer and SQL Server

Fursel 341 Reputation points
2021-11-26T14:08:29.36+00:00

Hello,

I would like to rollup health from SQL Server DB Engine to Windows Computer but don't really know how to do that.

Not sure where this relationship should be set. In SQL 2008 MP it seems it is there but not for the 2012 +

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,419 questions
0 comments
Accepted answer
  1. CyrAz 5,181 Reputation points
    2021-12-26T14:18:05.933+00:00

    I'll have to slightly disagree with Stoyan and Bob here : there actually is a native containment relationship between Windows Server and DB Engine class (
    https://systemcenter.wiki/?GetElement=Microsoft.SQLServer.Windows.ServerComputerContainsDBEngine&Type=RelationshipType&ManagementPack=Microsoft.SQLServer.Windows.Discovery&Version=7.0.32.0 )
    Not too sure whether a native monitor based on that relationship does exist though and I can't verify it now, but anyway you should be able to create a dependency monitor using SCOM console "Authoring" pane.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. SChalakov 10,266 Reputation points MVP
    2021-11-28T16:33:17.97+00:00

    Hi @Fursel ,

    which SQL MP do you mean exactly? The new version agnostic SQL MP?
    If yes, than you need to know that it has been re-written and the DB engine class is not hosted by Windows Computer class anymore. This is visible when you compare the clas hierrachies in both the old and the new SQL MPs. Here is an example with the old SQL Server 2012 (it is the same also for SQL Server 2008, and 2014):

    from:
    SQL Server 2012 DB Engine
    https://systemcenter.wiki/?GetElement=Microsoft.SQLServer.2012.DBEngine&Type=ClassType&ManagementPack=Microsoft.SQLServer.2012.Discovery&Version=7.0.15.0

    153097-capture.png

    and here how it looks in the re-written class model:

    from:
    MSSQL on Windows: Local DB Engine
    https://systemcenter.wiki/?GetElement=Microsoft.SQLServer.Windows.LocalDBEngine&Type=ClassType&ManagementPack=Microsoft.SQLServer.Windows.Discovery&Version=7.0.32.0

    153040-capture.png

    Did this answer your question? I hope I could help out.

    ----------

    If my reply was helpful please don't forget to upvote and/or accept as answer, thank you!
    Regards,
    Stoyan

  2. Bob Cornelissen 251 Reputation points MVP
    2021-12-24T19:20:23.287+00:00

    A good explanation by SToyan. And I think if you wanted to you could create this dependency somehow.

    The question is always to think about why that is needed. Are you using dashboards which only have the full Windows Computer objects on them? The whole idea of SCOM is that you may be interested in the state of some objects living on a computer - separate from that computer. For example to create a dashboard with some SQL databases on it. Or a single DB engine, which belongs to one application and another engine (sql instance) belonging to another application. In many dashboards and distributed apps created in SCOM the full computer isnt added but the objects involved in the application itself. Just depends on your situation. Just wanted to write this additional thought to this.