How can we help you today? How can we help you today?

Monitoring Stopped on Servers After Latest Windows Patches Applied

We are on SQL Monitor 12.0.13. Last Sunday our IT department patched all our DEV and QA SQL Servers with the latest Windows Server patches (Mix of Windows Server 2012, 2016 and 2019) and monitoring on these servers now fails.

Here is an excerpt from the log on one of the server instances. Any thoughts:

18 Jan 2022 11:53 AM WMI GetInstances: root\cimv2 select Name,State,StartMode,StartName from Win32_Service Cannot connect COMException The object invoked has disconnected from its clients. (0x80010108 (RPC_E_DISCONNECTED))
18 Jan 2022 11:51 AM WMI ReadRegistry Cannot connect COMException The object invoked has disconnected from its clients. (0x80010108 (RPC_E_DISCONNECTED))
TUellner
0

Comments

10 comments

Sort by
  • MarkLathrope
    I am seeing the same issue on one of our clusters with the 12.0.13 release as well, the monitored cluster is Windows Server Windows 2012 R2  (I know...) with SQL 2016, SP2 CU17.
    MarkLathrope
    0
  • MarkLathrope
    The patches I see applied to the cluster I am seeing this error on are Update for KB2504637, Update for MS Visual Studio 2015 (KB3095681) and (KB4336999)
    MarkLathrope
    0
  • Alex B
    Hi All,

    We're currently looking into this issue (where SQL Monitor isn't reconnecting after the monitored entities are restarted after updates), but in the interim, if you restart the SQL Monitor services this should get the monitoring of the entity going again.

    I'll update further once I have more information from the investigation with the developers.

    Kind regards,
    Alex
    Alex B
    0
  • TUellner
    The cumulative update we had to roll back was Microsoft KB#5009557
    TUellner
    0
  • Alex B
    Hi @TUellner,

    Just to confirm, you've rolled back that particular KB and then the servers reconnected?  Had you tried restarting SQL Monitor before that to see if they reconnected then, or had you already rolled back the KB you've mentioned?

    Kind regards,
    Alex
    Alex B
    0
  • MarkLathrope
    I restarted my SQL Base monitor service per your recommendation and that resolved the issue as well, with no KB rollbacks.  Thanks!
    MarkLathrope
    0
  • TUellner
    I had the same experience as Mark. Restarted the SQL Monitor services and the other servers came back into a monitored state.
    TUellner
    0
  • Alex B
    Righto, that's good to hear! 

    I believe the team will have a fix for the issue in the release tomorrow 12.0.14, so I'll post that here when it's available as well.
    Alex B
    0
  • Alex B
    Hi all,

    SQL Monitor 12.0.14 has been released with a change the developer believe will address this issue.  You can download it here: https://download.red-gate.com/checkforupdates/SQLMonitorWeb/SQLMonitorWeb_12.0.14.21317.exe

    Do let me know how you get on with the new version in regards to this issue!

    Kind regards,
    Alex
    Alex B
    0
  • TUellner
    Alex,

    I installed the release and I was able to restart one of the updated SQL Servers with the MS update and SQL Monitor went right back to monitoring the server as soon as it restarted. Thanks to the development team for getting this fixed so quickly!

    -Tom
    TUellner
    0

Add comment

Please sign in to leave a comment.