SQL Server bulk insert on VMBulk insert into SQL Server from VMWare guest using distributed switchSQL Server...
When should a starting writer get his own webpage?
Was World War I a war of liberals against authoritarians?
CLI: Get information Ubuntu releases
Is xar preinstalled on macOS?
Would this string work as string?
What will the Frenchman say?
What is 管理しきれず?
Homology of the fiber
Help with identifying unique aircraft over NE Pennsylvania
What is the reasoning behind standardization (dividing by standard deviation)?
Norwegian Refugee travel document
What (if any) is the reason to buy in small local stores?
Do I need an EFI partition for each 18.04 ubuntu I have on my HD?
Recursively updating the MLE as new observations stream in
Does convergence of polynomials imply that of its coefficients?
Do native speakers use "ultima" and "proxima" frequently in spoken English?
10 year ban after applying for a UK student visa
Asserting that Atheism and Theism are both faith based positions
What is the difference between something being completely legal and being completely decriminalized?
is this saw blade faulty?
Should I be concerned about student access to a test bank?
What is the tangent at a sharp point on a curve?
How old is Nick Fury?
Could any one tell what PN is this Chip? Thanks~
SQL Server bulk insert on VM
Bulk insert into SQL Server from VMWare guest using distributed switchSQL Server account delegation setupHow to provision the SQL Server Agent service after SQL Server Edition upgradeLinked Server Error on SQL Agent JobConfigure unconstrained delegation for BULK INSERTSQL Plan GuidesBulk insert and fast ordered search large data 3B+ recordsInsert into linked server fails with “The transaction manager has disabled its support for remote/network transactions”SQL Server: INSERT-SELECT Statement occasionally fails silently and works upon re-run2 SQL 2019 Servers with High Availability Linux with a shared Linux SQL Express 2019 Witness
This is mostly likely not a SQL server issue but the setup seems to only be affecting BULK INSERTS to SQL Servers.
We have recently moved VM Hardware and all the guests that were moved had their virtual switches changed from standard to distributed.
I then started receiving
A fatal error occurred while reading the input stream from the network. The session will be terminated (input error: 64, output error: 0)
on a two SQL servers during BULK INSERT operations. One of the SQL servers was a VM with the new configuration and the other was a physical server. Both BULK INSERT operation originated from a VM with the new configuration. The BULK INSERTs would not fail every time, it was very random when it would.
When we changed the virtual switch to be a standard switch instead of a distributed switch the issue goes away.
I am looking for more of an explanation to why it doesn't work with a distributed switch instead of a resolution. My guess would be that the BULK INSERT operation is serial and with a distributed switch the packets are being routed through different hosts, some of which may be busier than others, and are arriving at the destination server beyond some latency threshold. (note: there is nothing in the windows event log at the times of the errors on either the source or destination server)
https://www.sqlservercentral.com/Forums/Topic1394090-391-1.aspx
sql-server
asked May 3 '17 at 14:03
AJ's SQLAJ's SQL
538
bumped to the homepage by Community♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
This is mostly likely not a SQL server issue but the setup seems to only be affecting BULK INSERTS to SQL Servers.
We have recently moved VM Hardware and all the guests that were moved had their virtual switches changed from standard to distributed.
I then started receiving
A fatal error occurred while reading the input stream from the network. The session will be terminated (input error: 64, output error: 0)
on a two SQL servers during BULK INSERT operations. One of the SQL servers was a VM with the new configuration and the other was a physical server. Both BULK INSERT operation originated from a VM with the new configuration. The BULK INSERTs would not fail every time, it was very random when it would.
When we changed the virtual switch to be a standard switch instead of a distributed switch the issue goes away.
I am looking for more of an explanation to why it doesn't work with a distributed switch instead of a resolution. My guess would be that the BULK INSERT operation is serial and with a distributed switch the packets are being routed through different hosts, some of which may be busier than others, and are arriving at the destination server beyond some latency threshold. (note: there is nothing in the windows event log at the times of the errors on either the source or destination server)
https://www.sqlservercentral.com/Forums/Topic1394090-391-1.aspx
sql-server
asked May 3 '17 at 14:03
AJ's SQLAJ's SQL
538
bumped to the homepage by Community♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
This is mostly likely not a SQL server issue but the setup seems to only be affecting BULK INSERTS to SQL Servers.
We have recently moved VM Hardware and all the guests that were moved had their virtual switches changed from standard to distributed.
I then started receiving
A fatal error occurred while reading the input stream from the network. The session will be terminated (input error: 64, output error: 0)
on a two SQL servers during BULK INSERT operations. One of the SQL servers was a VM with the new configuration and the other was a physical server. Both BULK INSERT operation originated from a VM with the new configuration. The BULK INSERTs would not fail every time, it was very random when it would.
When we changed the virtual switch to be a standard switch instead of a distributed switch the issue goes away.
I am looking for more of an explanation to why it doesn't work with a distributed switch instead of a resolution. My guess would be that the BULK INSERT operation is serial and with a distributed switch the packets are being routed through different hosts, some of which may be busier than others, and are arriving at the destination server beyond some latency threshold. (note: there is nothing in the windows event log at the times of the errors on either the source or destination server)
https://www.sqlservercentral.com/Forums/Topic1394090-391-1.aspx
sql-server
asked May 3 '17 at 14:03
AJ's SQLAJ's SQL
538
This is mostly likely not a SQL server issue but the setup seems to only be affecting BULK INSERTS to SQL Servers.
We have recently moved VM Hardware and all the guests that were moved had their virtual switches changed from standard to distributed.
I then started receiving
A fatal error occurred while reading the input stream from the network. The session will be terminated (input error: 64, output error: 0)
on a two SQL servers during BULK INSERT operations. One of the SQL servers was a VM with the new configuration and the other was a physical server. Both BULK INSERT operation originated from a VM with the new configuration. The BULK INSERTs would not fail every time, it was very random when it would.
When we changed the virtual switch to be a standard switch instead of a distributed switch the issue goes away.
I am looking for more of an explanation to why it doesn't work with a distributed switch instead of a resolution. My guess would be that the BULK INSERT operation is serial and with a distributed switch the packets are being routed through different hosts, some of which may be busier than others, and are arriving at the destination server beyond some latency threshold. (note: there is nothing in the windows event log at the times of the errors on either the source or destination server)
https://www.sqlservercentral.com/Forums/Topic1394090-391-1.aspx
sql-server
sql-server
asked May 3 '17 at 14:03
AJ's SQLAJ's SQL
538
asked May 3 '17 at 14:03
AJ's SQLAJ's SQL
538
asked May 3 '17 at 14:03
AJ's SQLAJ's SQL
538
asked May 3 '17 at 14:03
AJ's SQLAJ's SQL
538
asked May 3 '17 at 14:03
AJ's SQLAJ's SQL
538
538
bumped to the homepage by Community♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Check what virtual NIC the VMs are using? if you are using E1000 NIC, change it to the VMXNET3. This resolved my issue when doing large transfers using VMWare distributed switches.
answered May 3 '17 at 14:21
Bob KlimesBob Klimes
2,1701023
Bob - yes its is set to VMAXNET3 & still having issues.
– AJ's SQL
May 3 '17 at 16:38
@AJ'sSQL are both guests vmxnet3? I also had issues if other vms on same host had other NIC
– Bob Klimes
May 3 '17 at 20:24
Bob - another host is physical not VM so that don't have these settings.
– AJ's SQL
May 3 '17 at 21:15
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
});
}
});
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%2fdba.stackexchange.com%2fquestions%2f172628%2fsql-server-bulk-insert-on-vm%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Check what virtual NIC the VMs are using? if you are using E1000 NIC, change it to the VMXNET3. This resolved my issue when doing large transfers using VMWare distributed switches.
answered May 3 '17 at 14:21
Bob KlimesBob Klimes
2,1701023
Bob - yes its is set to VMAXNET3 & still having issues.
– AJ's SQL
May 3 '17 at 16:38
@AJ'sSQL are both guests vmxnet3? I also had issues if other vms on same host had other NIC
– Bob Klimes
May 3 '17 at 20:24
Bob - another host is physical not VM so that don't have these settings.
– AJ's SQL
May 3 '17 at 21:15
add a comment |
Check what virtual NIC the VMs are using? if you are using E1000 NIC, change it to the VMXNET3. This resolved my issue when doing large transfers using VMWare distributed switches.
answered May 3 '17 at 14:21
Bob KlimesBob Klimes
2,1701023
Bob - yes its is set to VMAXNET3 & still having issues.
– AJ's SQL
May 3 '17 at 16:38
@AJ'sSQL are both guests vmxnet3? I also had issues if other vms on same host had other NIC
– Bob Klimes
May 3 '17 at 20:24
Bob - another host is physical not VM so that don't have these settings.
– AJ's SQL
May 3 '17 at 21:15
add a comment |
Check what virtual NIC the VMs are using? if you are using E1000 NIC, change it to the VMXNET3. This resolved my issue when doing large transfers using VMWare distributed switches.
answered May 3 '17 at 14:21
Bob KlimesBob Klimes
2,1701023
Check what virtual NIC the VMs are using? if you are using E1000 NIC, change it to the VMXNET3. This resolved my issue when doing large transfers using VMWare distributed switches.
answered May 3 '17 at 14:21
Bob KlimesBob Klimes
2,1701023
answered May 3 '17 at 14:21
Bob KlimesBob Klimes
2,1701023
answered May 3 '17 at 14:21
Bob KlimesBob Klimes
2,1701023
answered May 3 '17 at 14:21
Bob KlimesBob Klimes
2,1701023
2,1701023
Bob - yes its is set to VMAXNET3 & still having issues.
– AJ's SQL
May 3 '17 at 16:38
@AJ'sSQL are both guests vmxnet3? I also had issues if other vms on same host had other NIC
– Bob Klimes
May 3 '17 at 20:24
Bob - another host is physical not VM so that don't have these settings.
– AJ's SQL
May 3 '17 at 21:15
add a comment |
Bob - yes its is set to VMAXNET3 & still having issues.
– AJ's SQL
May 3 '17 at 16:38
@AJ'sSQL are both guests vmxnet3? I also had issues if other vms on same host had other NIC
– Bob Klimes
May 3 '17 at 20:24
Bob - another host is physical not VM so that don't have these settings.
– AJ's SQL
May 3 '17 at 21:15
Bob - yes its is set to VMAXNET3 & still having issues.
– AJ's SQL
May 3 '17 at 16:38
Bob - yes its is set to VMAXNET3 & still having issues.
– AJ's SQL
May 3 '17 at 16:38
@AJ'sSQL are both guests vmxnet3? I also had issues if other vms on same host had other NIC
– Bob Klimes
May 3 '17 at 20:24
@AJ'sSQL are both guests vmxnet3? I also had issues if other vms on same host had other NIC
– Bob Klimes
May 3 '17 at 20:24
Bob - another host is physical not VM so that don't have these settings.
– AJ's SQL
May 3 '17 at 21:15
Bob - another host is physical not VM so that don't have these settings.
– AJ's SQL
May 3 '17 at 21:15
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f172628%2fsql-server-bulk-insert-on-vm%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
