With AlwaysOn, there are 3 options for the keyword
- True (yes)
- False (no) (example)
- Not sent/used
Not all applications support it's use in connection strings. Not all vendor contacts understand it's importance to performance at failover.
As a DBA I would like to be able to validate what property is being used by the application connection. If I have not made the appropriate setting change to
RegisterAllProvidersIP it can cause issues. See: Follow-up: After Creating an Availability Group Listener
How can I capture what (if any) keyword values were used to create a connection to one of my instances?