sp_server_diagnostics in ErrorLog

• Casper101

  Hall of Fame

  Points: 3903

  More actions

  June 24, 2024 at 12:42 pm

  #4431064

  I have the following in the SQL Errorlog, that was never there before:

  sp_server_diagnostics encountered a long delay that was 2.5 times more than the repeat interval between two consecutive diagnostics result generations.

  The repeat interval: 300000000, the elapsed time of this diagnostics result generation: *****, the elapsed time between the latest two diagnostics result generations: ********.

  My understanding is that sp_server_diagnostics relates to AG health and cluster monitoring.

  But this SQL Server is not in a cluster, with no AlwaysOn

  It is SQL Server 2022 running on Linux

  Any ideas why this would flood the errorlog?

  Can I turn it off? Any risk in doing so?

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  June 25, 2024 at 1:10 pm

  #4431334

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

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