PolyBasẽm[hԂptH[}XɊւo͂FSQL ServerIǗr[t@Xi44j
uMicrosoft SQL Servervғf[^x[XVXe^pǗ҂ɌAuIǗr[v̊pɂgû߂̃mEnEЉĂ܂B́APolyBasẽm[hԂptH[}XɊւ̏o͂ɂĉ܂B
» 2021N0921 0500 J
[ŖjCIT]
̋L͉łBo^ijƑSĂ܂B
@{Aڂł́AuMicrosoft SQL ServeriȉASQL ServerjvŎgp\ȓIǗr[ɂāATvo͓eȂǂЉĂ܂B͓IǗr[usys.dm_exec_compute_node_statusvɂAuPolyBaseṽm[hԂptH[}XɊւ̏o͂ɂĉ܂BΉo[ẂASQL Server 2016ȍ~łB
Tv
@K̓f[^Iɏ邱ƂłuHadoopvɑāASQL ServerPolyBasegpĐڑł܂BAʂ̃f[^ɓAPSQL Serverł̓{glbNAz肵ptH[}XłȂƂ܂B
@PolyBaseXP[AEgO[vō\ƕŏ邱Ƃł邽߁AptH[}Xコ܂Busys.dm_exec_compute_node_statusvsƁAPolyBasẽm[h̏ԂptH[}XɊւo͂܂B
o͓e
| f[^^ | ||
|---|---|---|
| compute_node_id | int | m[hɊ֘AtĂID |
| process_id | int | PolyBasẽvZXID |
| process_name | nvarchari255j | m[h̘_ |
| allocated_memory | bigint | ̃m[hŊ蓖Ăꂽ̍v |
| available_memory | bigint | ̃m[hŎgp\ȃ̍v |
| process_cpu_usage | bigint | vZX̑CPUgp |
| total_cpu_usage | bigint | vCPUgp |
| thread_count | bigint | ̃m[hŎgpĂXbh̍v |
| handle_count | bigint | ̃m[hŎgp̃nh̍v |
| total_elapsed_time | bigint | VXe̋N܂͍ċŇoߎ |
| is_available | bit | ̃m[hgpł邩ǂtO |
| sent_time | datetime | ŌɑMlbg[NpbP[W̓ |
| received_time | datetime | ŌɎMlbg[NpbP[W̓ |
| error_id | nvarchari36j | ̃m[hŔŌ̃G[ID |
֘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.
SpecialPR
X|T[̂m点PR
SpecialPR
ڂ̃e[}
VXeJmEnE yirzPR
Ȃɂ߂̋LPR
ITmedia̓ACeBfBAЂ̓o^WłB