SCOM2019 - Monitor SQL Error log of SQL2017 instances

Rives, Vincent 1 Reputation point
2021-09-15T16:10:38.207+00:00

Hi
Our 2-node Win2019 cluster hosts 3 x SQL2017 instances configured in FCI (Failover Cluster Instance).

My SCOM admin nicely configured the monitoring of the SQL error log files at the node level because he could not do at the database instance level in SCOM. When an error occurs in one particular SQL instance, I receive SCOM alerts coming from all the SQL instances which does not help me to locate where the error is coming from.

How can we configure SCOM to monitor SQL errors and received alerts from the concerned SQL instance?

Is there any documentation for that? I spent time on the great Kevin Holman's blog without luck.

Thanks for your help,
Vincent

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,433 questions
Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
880 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,067 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
969 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Limitless Technology 39,461 Reputation points
    2021-09-16T07:42:17.097+00:00

    Hello, Vincent,

    Here is a thread that you can use for reference:

    SCOM 2016 - How to get threshold details for important monitors

    https://learn.microsoft.com/en-us/answers/questions/380606/scom-2016-how-to-get-thresold-details-for-importan.html

    Also some additional information regarding Monitoring Configuration in Management Pack for SQL Server

    https://learn.microsoft.com/en-us/system-center/scom/sql-server-management-pack-monitoring-configuration?view=sc-om-2019

    I hope this will help you!
    Regards,

    0 comments No comments