0

I am using 1 node SQL Server 2016, having linked servers using MSOLEDBSQL provider and Provider string "MultiSubnetFailover=Yes". Are there any implications/negative impacts, if i use "MultiSubnetFailover=Yes" to create linked servers in standalone SQL Server 2016. OR "MultiSubnetFailover=Yes" should only be used in Alwayson setup.

Improve this question

1 Answer 1

Reset to default
1

I dont see a benefit of using MultiSubnetFailover for a sandalone server since you dont have failovers, no listener is configured and its a single point of failure. There is obviously a performance gain when using MultiSubnetFailover in a DR situation.

Improve this answer
1
  • Is it possible to use 'MultiSubnetFailover=Yes' with SQLNCLI11 or SQLOLEDB? Or only with MSOLEDBSQL?
    – yoma
    Commented Aug 30, 2023 at 16:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.