What do the failover clustering logs say? (you may want to try clearing them to let fresh logs reaccumulate if the log file is excessively large)

To start - CU6 is an unsupported CU. You would need to be at least up to CU8. Is Windows also held back more than two CU?

oh also confirm it is actually using OpenSSL. it could be using a different TLS client

If it is server 2022/supports TLS 1.3 server, you can probably dismiss TLS as a problem. TLS 1.3 removes most of the latitude developers had to implement TLS poorly or...

is the client configured to use tls 1.2 with a valid cipher suite? TLS 1.0, 1.1** are turned off by default in 2019+

Does the 6% performance reduction pose a real operational problem at the system level?

At the micro scale, small performance reductions may not matter to the individual process incurring it, but...

oh good catch. It keyword formatted 'identity' and it confused me.

I took OP's original statement to mean that the process worked with 12 rows at a time and 12 new...

Have you looked at blocking to see what types of locks are blocking?

Are the sort values of [colum1], [column2] always sequential? If they are not, you will be inserting into...

Have you looked at blocking to see what types of locks are blocking?

Are the sort values of [colum1], [column2] always sequential? If they are not, you will be inserting into...

Have you looked at blocking to see what types of locks are blocking?

Are the sort values of [colum1], [column2] always sequential? If they are not, you will be inserting into...

Ok I understand now - you problem is your connection strings. You need to enable multisubnet failover in the connection string, the SQL client goes through a step where it...

Why are you concerned with this? if you need fast multi-subnet failover, you have to have two IP addresses.

SQL 2022 will give you batch mode execution plans on indexes that are not columnstore, even if batch mode execution plans are slower.

Did you look at the execution plans yet?

Don't use CNAMES like that, you are asking for problems. It can break anything that is encrypted and/or implements mutual authentication.

you could try registering another A record for the old...

second page bump