That answer is going to depend on more factors than just user count.

For example, if your database is 100MB and those users are only pulling a single record...

Odd behavior, but good to know. Do bulk inserts via listener update both nodes at same time or something?

Do you mean IP vs hostname? DNS addresses defines the hostname, this is why I'm asking.

Could you illustrate an example of what you are seeing?

This question...

I see. How are you managing authentication to the DB within the maintenance plan? SSO with windows authentication or is utilizing a SQL user with encrypted password? 

I've had...

Did you fail over and back in the process of applying the patch? How often do you fail these over? Was it fixed after retracting the patch? Also, could you...

I don't believe so. Unfortunately I believe this is the only workaround to the behavior. You could try though, I have no experience with the "RegisterAllProvidersIP" flag.

You could...

Well for initial sizing out, we typically deploy some standard based on requirements and what we have seen based on other deployments. We then test and tweak in non production....

Sure but good luck restoring databases that are encrypted with TDE.

You will need that certificate to unpack it.

Nope - do your normal due diligence with tuning and statistics.

I have a few MSSQL RDS's under my scope and learned that the hard way. One of our...

The cranky performance tuner in me got a headache reading this thread 😉