Network disconnect between 2 DC's for SQL server The 2019 Stack Overflow Developer Survey...
How to create dashed lines/arrows in Illustrator
What are the motivations for publishing new editions of an existing textbook, beyond new discoveries in a field?
Limit the amount of RAM Mathematica may access?
Access elements in std::string where positon of string is greater than its size
Manuscript was "unsubmitted" because the manuscript was deposited in Arxiv Preprints
Unbreakable Formation vs. Cry of the Carnarium
If the Wish spell is used to duplicate the effect of Simulacrum, are existing duplicates destroyed?
What does "sndry explns" mean in one of the Hitchhiker's guide books?
Realistic Alternatives to Dust: What Else Could Feed a Plankton Bloom?
Extreme, unacceptable situation and I can't attend work tomorrow morning
It's possible to achieve negative score?
Is it possible for the two major parties in the UK to form a coalition with each other instead of a much smaller party?
Does light intensity oscillate really fast since it is a wave?
What is the motivation for a law requiring 2 parties to consent for recording a conversation
Is domain driven design an anti-SQL pattern?
Why is the maximum length of openwrt’s root password 8 characters?
Deadlock Graph and Interpretation, solution to avoid
"Riffle" two strings
Inflated grade on resume at previous job, might former employer tell new employer?
What is this 4-propeller plane?
What is the best strategy for white in this position?
Any good smartcontract for "business calendar" oracles?
Why is Grand Jury testimony secret?
Is three citations per paragraph excessive for undergraduate research paper?
Network disconnect between 2 DC's for SQL server
The 2019 Stack Overflow Developer Survey Results Are InDoes 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 3 mins ago
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 3 mins ago
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 3 mins ago
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 3 mins ago
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 3 mins ago
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 3 mins ago
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 3 mins ago
BeginnerDBABeginnerDBA
101
asked 3 mins ago
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
