SQL 2008 Monitoriing in SCOM 2019

Saravanan Balasubramanian 266 Reputation points
2020-11-04T23:13:08.933+00:00

Hi guys,

So is it possible to monitor SQL Server 2008 in SCOM 2019 ? i have imported almost all SQL monitoring management pack.

After reading the below SQL Server mgmt pack guide, I understand instead of importing all the SQL management packs from catalog, we can simply import the limited ones below and it can monitor SQL 2012 to 2019.

https://www.microsoft.com/en-us/download/details.aspx?id=56203

Your suggestion please. we would like to monitor SQL 2012 and above only. But if we want to monitor SQL 2008 as well, recommend the mgmt packs.

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. Leon Laude 85,666 Reputation points
    2020-11-05T06:09:08.25+00:00

    Hi @Saravanan Balasubramanian ,

    To monitor SQL Server 2012 - 2019 you use the new version-agnostic management pack:
    Microsoft System Center Management Pack for SQL Server

    To monitor SQL Server 2008 you will also have to import the latest version of the SQL Server 2008-2012 management pack:
    Microsoft System Center Management Pack for SQL Server

    ----------

    (If the reply was helpful please don't forget to upvote or accept as answer, thank you)

    Best regards,
    Leon

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest