MSSQL objects are not shown in health explorer

Brian W 121 Reputation points
2024-04-29T17:43:35.07+00:00

I should see the SQL Service and SQL agent service uner local applicaton health. I have the SQL for Windows version 7.4.0 running on SCOM 2022 R2, I cannot tell you when this broke, but I'm certain that it worked on my SCOM 2019 UR4 install that I just recently upgraded. After I was satisfied things were good, I used MP Updates and recommendations feature to upgrade the SQL MP to 7.4.0 from 7.2.0. Any suggestions for next steps?

User's image

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.
860 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. XinGuo-MSFT 15,011 Reputation points
    2024-04-30T09:36:20.7033333+00:00

    Hi,

    Use Health Explorer to find out which monitor is reflecting a health state issue and review knowledge about the monitor and possible causes for actions related to it.

    Select a monitor to view more information about the monitor in the Details pane. The State Change Events tab in the Details pane shows you when the state for the monitor changed, and the details give you information for the context of the state change.