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 10 posts - 1 through 9 (of 9 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?

~Sreejith G SSCrazy Points: 2311 More actions · Answer 6

Did anyone got solution for this issue? how can we stop getting this in Errorlog? its kind of spamming and annoying.

1111

This reply was modified 4 months, 1 week ago by ~Sreejith G.

~Sreejith G SSCrazy Points: 2311 More actions · Answer 7

~Sreejith G

SSCrazy

Points: 2311

May 13, 2024 at 6:12 pm

#4420943

Did anyone got solution for this issue?

1111

Steve Jones - SSC Editor SSC Guru Points: 735658 More actions · Answer 8

This service sends info back to Microsoft on product usage. If you have a licensed instance of SQL Server, you can disable.

https://www.sqlservercentral.com/blogs/disable-or-turn-off-sql-server-telemetry-service

DD266 Newbie Points: 1 More actions · Answer 9

To resolve this issue with SQL 2022, I stopped the SQL Server CEIP Service , set the startup type on that service as disabled and deleted the Telemetry_Xevents extended session from SQL Server. You can delete incase if you want. Stopping the service should help with extended event restart issue every 1 hr.