Seeing below errors in SQL Server 2022 error log

Question

Post reply

Seeing below errors in SQL Server 2022 error log

prem.m38

Ten Centuries

Points: 1117
More actions
August 7, 2023 at 6:54 pm

#4255187

XE session 'telemetry_xevents' is stopping and starting for every 1 hour . Please advise how to stop this.
A valid TLS certificate is not configured to accept strict (TDS 8.0 and above) connections. The connection has been closed.
An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')
Error: 9642, Severity: 16, State: 3.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80320 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Mr. SqlSeeks Newbie Points: 8 More actions · Answer 2

I just started seeing the same thing today, around the same time our vulnerability scanner started doing its thing. Is your SQL machine subject to vulnerability scans?

shivamg330 Newbie Points: 5 More actions · Answer 3

Try this

ALTER EVENT SESSION telemetry_xevents ON SERVER STATE = STOP;

Mr. SqlSeeks Newbie Points: 8 More actions · Answer 4

That might stop the events from happening but it doesn't tell us why they started appearing in the first place.

shivamg330 Newbie Points: 5 More actions · Answer 5

Please provide more details. You want to stop telemetry_xevents or you want to resolve the error that is coming up? How do you come to know that telemetry_xevents starts and stops every hours? Is it getting logged? Do you have service broker/ Always On enabled?