SQL2022 CU12 Question

• krypto69

  SSChampion

  Points: 13604

  More actions

  March 31, 2024 at 12:04 pm

  #4405421

  Hi.

  I installed SQL2022 CU12 and in the notes it says:

   

  2937584

  Fixes an issue in which the sp_server_diagnostics stored procedure doesn't respond to the Always On availability group (AG) resource DLL within the HealthCheckTimeout when the I/O takes a long time, which causes unnecessary restart and failover. For example, when the sp_server_diagnostics stored procedure is waiting for the PREEMPTIVE_OS_GETFINALFILEPATHBYHANDLE wait type.

  Note: To apply this fix, you need to turn on trace flag 16301, which is off by default. Tracing is added for this event regardless of the trace flag.

   

  I added the flag to startup on my primary and both secondary's. Is that correct - it's not just the primary is it?

  Can't find any info on this.

   

  • This topic was modified 8 months, 4 weeks ago by  krypto69.

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  April 1, 2024 at 12:10 pm

  #4405876

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

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