MultiSubnetFailover Performance
Glycerine
Posts: 5 Bronze 1
We use SQL 2012's clustering across multiple subnets for DR on our production servers. Whenever we connect to them, we always have to add the "MultiSubnetFailover=true" to the connection strings so it knows to simultaneously ping all subnets and find the one that is responding quickly. We do not directly link our production databases to source control, but when we have SSMS open with Source Control enabled, right clicking anything on that server, opening new tabs, switching DBs, almost everything is incredibly slow and oftentimes times out or crashes the program. If we open a second SSMS where source control does not load (we have that option disabled), everything works fine. What are the chances that Red Gate can add in this to how it connects to server or at least honor the additional connection string options entered when connecting to servers?
Comments
Thanks for your suggestion.
Can you please post it on our uservoice forum?
There's already a similar suggestion:
https://redgate.uservoice.com/forums/14 ... parameters
I suggest that you register on that forum and vote on that idea.
That forum is monitored by the Product Management team who use it as an important source when deciding what features to add or enhance.
Thank you,
Product Support Engineer
Redgate Software Ltd
Please see our Help Center for detailed guides on how to use our tools