Share via

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,601 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.
1,077 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.
14,492 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.
1,027 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Limitless Technology 39,906 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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.