PolyBaseŔG[Ɋւo͂FSQL ServerIǗr[t@Xi43j
uMicrosoft SQL Servervғf[^x[XVXe^pǗ҂ɌAuIǗr[v̊pɂgû߂̃mEnEЉĂ܂B́APolyBaseŔG[Ɋւ̏o͂ɂĉ܂B
̋L͉łBo^ijƑSĂ܂B
@{Aڂł́AuMicrosoft SQL ServeriȉASQL ServerjvŎgp\ȓIǗr[ɂāATvo͓eȂǂЉĂ܂B͓IǗr[usys.dm_exec_compute_node_errorsvɂAPolyBaseŔG[Ɋւ̏o͂ɂĉ܂BΉo[ẂASQL Server 2016ȍ~łB
Tv
@SQL Server 2016APolyBaseƌĂO\[Xf[^ǂݎ@\܂BOf[^ɂ͍\ĂȂf[^Ȃǂwł邽߁ASQL Server̃f[^ƌɂ́Af[^̎擾O͎擾Ɍ`킹Kv܂BPolyBaseł͊Of[^Transact SQLŏł悤ɂȂ邽߁ASQL ServerƂ̃f[^eՂɂȂ܂Busys.dm_exec_compute_node_errorsvsƁAPolyBaseŔG[Ɋւo͂܂B
o͓e
| f[^^ | ||
|---|---|---|
| error_id | nvarchari36j | G[Ɋ֘AtĂID |
| source | nvarchari255j | \[XXbh܂̓vZX̐ |
| type | nvarchari255j | G[̎ |
| create_time | datetime | G[̔ |
| compute_node_id | int | vZm[hID |
| rexecution_id | nvarchari36j | PolyBaseNGID |
| spid | int | SQL ServerZbVID |
| thread_id | int | G[XbhID |
| details | nvarchari4000j | G[̏ڍׂȐ |
@PolyBasẽXP[AEgO[v\Łusys.dm_exec_compute_node_errorsvsƁAPolyBaseɊւG[̏o͂܂i}1jBȂAΏۂ邽߂Ɂuerror_idvŕבւĂ܂Aʏ̊mFł̕בւ͕Kv܂B
@usourcevɂ́uDmsviData Movement ServicejuDWEngineviData Warehouse EnginejȂǁAT[rX̎ނo͂ĂAucompute_node_idvł1`3ȂǕ̒lo͂Ă邽߁A\SẴm[h̃G[bZ[Wꗗ\łĂ邱ƂmFł܂B
@ucompute_node_idv́ǍЉusys.dm_exec_compute_notesv̓IǗr[ƌ邱ƂŁA}VȂǂł܂Budetailsvɂ́uSystem.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote hostvȂǂ̃G[bZ[W̏ڍׂL^Ă܂B
@ȂA{ŎsƁAP[IDu1033vƁu1041vňvȂƂ̃bZ[WƂƂɁAusys.dm_exec_compute_node_errorsvG[Iꍇ邽ߒӂKvłB
{TipśAuWindows Server 2019vɁuSQL Server 2019 RC1vCXg[z肵ĉĂ܂B
MҏЉ
Ŗ ji j
{jVXЏBMicrosoft MVP for Data Platformi2017`jBЈȗ SQL Server̕]^v^\z^ȂǂɌgȂAɃT|[gƖɏ]BSQL Server̃guΉŎВ܂̕\oBx͊w̒ԂƎsw`ɎQAKŊ𗬂Ă݉ւƗB
ɓ q́iƂ Ƃj
{jVXЏBЈȗSQL Serverŕ]^v^\z^ȂǂɌgȂAɃT|[gƖɏ]BГ̃vO~OReXg4̗DoB͗֍sŏT͎]ԂĂ̗sBڕW͐FXȓ{SI𐧔e邱ƁB
֘AL
SQL Server̓IǗr[Ƃ́H
uMicrosoft SQL Servervғf[^x[XVXe^pǗ҂ɌAuIǗr[v̊pɂgû߂̃mEnEЉĂ܂B
uDMViDynamic Management ViewjvŃptH[}Xx́uvׂ
{Aڂ́AuMicrosoft SQL ServervŔguuǂȕ@Łvuǂ̂悤ɁvĂAΏ̂߂̃mEnEЉ܂B́Aux̌NjgDMV̎ghv܂B
SQL Server̓𐧌䂷ug[XtOvƂ͉
uMicrosoft SQL Servervғf[^x[XVXe^pǗ҂ɌAug[XtOv̊pɂgû߂̃mEnEЉĂ܂B́ug[XtOƂ͂v܂B
Copyright © ITmedia, Inc. All Rights Reserved.
ڂ̃e[}
ITmedia̓ACeBfBAЂ̓o^WłB