Network disconnect between 2 DC's for SQL server Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Come Celebrate our 10 Year Anniversary!Does Always On in Sql Server 2016 work better with Windows Server 2016?SQL Server 2016 - Server crashSQL on Server Core pitfallsMS SQL Server Errors/secDoes SQL Server 2016 Support Windows Server 2016 Essentials?SQL Server 2016: Invisible AliasSQL Server 2016 Install entering Single User ModeIs Windows able to run Disk Optimize with SQL Server running?Sql Server shows as running process but does not show in Services PanelWhat may increase the latency 3-4 times for SQL FCI the database?
Multi tool use
Unexpected result with right shift after bitwise negation
Is there a documented rationale why the House Ways and Means chairman can demand tax info?
Is drag coefficient lowest at zero angle of attack?
Are my PIs rude or am I just being too sensitive?
Do working physicists consider Newtonian mechanics to be "falsified"?
What are the performance impacts of 'functional' Rust?
Is above average number of years spent on PhD considered a red flag in future academia or industry positions?
What did Darwin mean by 'squib' here?
Antler Helmet: Can it work?
How to set letter above or below the symbol?
Is dark matter really a meaningful hypothesis?
If I can make up priors, why can't I make up posteriors?
New Order #5: where Fibonacci and Beatty meet at Wythoff
How can you insert a "times/divide" symbol similar to the "plus/minus" (±) one?
Why use gamma over alpha radiation?
Autumning in love
Cauchy Sequence Characterized only By Directly Neighbouring Sequence Members
How does the Nova's Burn power work at the 7-9 level?
Why is "Captain Marvel" translated as male in Portugal?
How can I protect witches in combat who wear limited clothing?
What was the last x86 CPU that did not have the x87 floating-point unit built in?
Who can trigger ship-wide alerts in Star Trek?
Need a suitable toxic chemical for a murder plot in my novel
Two different pronunciation of "понял"
Network disconnect between 2 DC's for SQL server
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
Come Celebrate our 10 Year Anniversary!Does Always On in Sql Server 2016 work better with Windows Server 2016?SQL Server 2016 - Server crashSQL on Server Core pitfallsMS SQL Server Errors/secDoes SQL Server 2016 Support Windows Server 2016 Essentials?SQL Server 2016: Invisible AliasSQL Server 2016 Install entering Single User ModeIs Windows able to run Disk Optimize with SQL Server running?Sql Server shows as running process but does not show in Services PanelWhat may increase the latency 3-4 times for SQL FCI the database?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
We are trying to resolve NW latency issue for one of our new build servers which is not yet live but migrated databases for testing in SQL2016 on windows 2016 with mirroring setup
Instance A - Total 10 TB databases with P in DC1
Instance b - Mirror with A in DC2
Distance between DC1 and DC2 is approx 20 miles, so not really a DR but works.
During the mirroring we see random disconnects though send and restore rate seems to be better.
Even though i am working with my NW engineers for some time now , but wanted an opinion of what might be going wrong here
When i ping SQL Virtual name say instance A from DC1 to DC2 instance B, for say 30 mins, there is almost 2 to 3% loss of packets. Around lost = 10 to 15 on avg. Mirror time out p[partner is default 10, should changing this mean anything if there is a drop in packets and how much can be acceptable ?
Load- Just random 50 GB load and nothing major
networking windows-server-2016 sql-server-2016
asked Apr 10 at 0:29
BeginnerDBABeginnerDBA
101
New contributor
BeginnerDBA is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
We are trying to resolve NW latency issue for one of our new build servers which is not yet live but migrated databases for testing in SQL2016 on windows 2016 with mirroring setup
Instance A - Total 10 TB databases with P in DC1
Instance b - Mirror with A in DC2
Distance between DC1 and DC2 is approx 20 miles, so not really a DR but works.
During the mirroring we see random disconnects though send and restore rate seems to be better.
Even though i am working with my NW engineers for some time now , but wanted an opinion of what might be going wrong here
When i ping SQL Virtual name say instance A from DC1 to DC2 instance B, for say 30 mins, there is almost 2 to 3% loss of packets. Around lost = 10 to 15 on avg. Mirror time out p[partner is default 10, should changing this mean anything if there is a drop in packets and how much can be acceptable ?
Load- Just random 50 GB load and nothing major
networking windows-server-2016 sql-server-2016
asked Apr 10 at 0:29
BeginnerDBABeginnerDBA
101
New contributor
BeginnerDBA is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
We are trying to resolve NW latency issue for one of our new build servers which is not yet live but migrated databases for testing in SQL2016 on windows 2016 with mirroring setup
Instance A - Total 10 TB databases with P in DC1
Instance b - Mirror with A in DC2
Distance between DC1 and DC2 is approx 20 miles, so not really a DR but works.
During the mirroring we see random disconnects though send and restore rate seems to be better.
Even though i am working with my NW engineers for some time now , but wanted an opinion of what might be going wrong here
When i ping SQL Virtual name say instance A from DC1 to DC2 instance B, for say 30 mins, there is almost 2 to 3% loss of packets. Around lost = 10 to 15 on avg. Mirror time out p[partner is default 10, should changing this mean anything if there is a drop in packets and how much can be acceptable ?
Load- Just random 50 GB load and nothing major
networking windows-server-2016 sql-server-2016
asked Apr 10 at 0:29
BeginnerDBABeginnerDBA
101
New contributor
BeginnerDBA is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
We are trying to resolve NW latency issue for one of our new build servers which is not yet live but migrated databases for testing in SQL2016 on windows 2016 with mirroring setup
Instance A - Total 10 TB databases with P in DC1
Instance b - Mirror with A in DC2
Distance between DC1 and DC2 is approx 20 miles, so not really a DR but works.
During the mirroring we see random disconnects though send and restore rate seems to be better.
Even though i am working with my NW engineers for some time now , but wanted an opinion of what might be going wrong here
When i ping SQL Virtual name say instance A from DC1 to DC2 instance B, for say 30 mins, there is almost 2 to 3% loss of packets. Around lost = 10 to 15 on avg. Mirror time out p[partner is default 10, should changing this mean anything if there is a drop in packets and how much can be acceptable ?
Load- Just random 50 GB load and nothing major
networking windows-server-2016 sql-server-2016
networking windows-server-2016 sql-server-2016
asked Apr 10 at 0:29
BeginnerDBABeginnerDBA
101
New contributor
BeginnerDBA is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Apr 10 at 0:29
BeginnerDBABeginnerDBA
101
New contributor
BeginnerDBA is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Apr 10 at 0:29
BeginnerDBABeginnerDBA
101
New contributor
BeginnerDBA is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Apr 10 at 0:29
BeginnerDBABeginnerDBA
101
asked Apr 10 at 0:29
BeginnerDBABeginnerDBA
101
101
New contributor
BeginnerDBA is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
BeginnerDBA is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
BeginnerDBA is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
BeginnerDBA is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f962337%2fnetwork-disconnect-between-2-dcs-for-sql-server%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
BeginnerDBA is a new contributor. Be nice, and check out our Code of Conduct.
BeginnerDBA is a new contributor. Be nice, and check out our Code of Conduct.
BeginnerDBA is a new contributor. Be nice, and check out our Code of Conduct.
BeginnerDBA is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f962337%2fnetwork-disconnect-between-2-dcs-for-sql-server%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
n RyRXhw tylJLwA bH,HQE4m,8FdJdA2IFzeCH ab7z7God 8YjHDdDUO9Wa7N aAr60U8u5WDqGsV,ZKe,8JDTQWE,v5CQlYRTAjoGyT6G
