SQL2022 CU12 Question

  • 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 2 weeks, 4 days ago by  krypto69.
  • Thanks for posting your issue and hopefully someone will answer soon.

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

Viewing 2 posts - 1 through 1 (of 1 total)

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