paste the query and the ddl of the tables including the indexes (anonymizing field names if necessary) and we can take a look at it

I don't know what Kafka does.

I don't think serverless or hyperscale do anything to solve any of your existing problems other than perhaps capacity requirements.

To me the resource limits for...

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...

If you are already using MI, you are experiencing regular (short) maintenance outages. If you haven't noticed them, that may be a good spot to start looking for where you...

woops, jumped the gun on that

second page bump

I don't think any of us understand exactly what you are asking.

I can say only one thing for sure: "zero downtime" is never a requirement, it is a fantasy.

First, not to be pedantic, but there are no 'zero downtime' systems. If you can define a realistic downtime tolerance (even if it is five 9s) you can review product...

the search for duplicate SPN is setspn -X If there are a lot of them, redirect to a notepad so you can search it

if you add -F it will search...

are those public IP addresses?

to move databases, I have always removed the replica from a server, then seed a new one from backup on the preferred volume and add it back to the availability...

Personally, I would do a single wildcard certificate. you will need the hostname of each SQL server however and the listeners at minimum

The port scanner may not be scanning all of them. Scans like those may only sample the hosts and over the course of a week scan all of them.

I typically...

As for having only 2 votes in an AG means that if the voters lose the ability to communicate with each other, each will have a vote of 1...

You can remove a vote from a node, in your case I don't think it would help anything on its own, there are quorum problems happening with at least two...