SQL DatabaseɑĎsꂽɊւo͂FSQL ServerIǗr[t@Xi38j
uMicrosoft SQL Servervғf[^x[XVXe^pǗ҂ɌAuIǗr[v̊pɂgû߂̃mEnEЉĂ܂B́AAzure SQL DatabaseɑĎsꂽɊւ̏o͂ɂĉ܂B
» 2021N0830 0500 J
[ŖjCIT]
̋L͉łBo^ijƑSĂ܂B
@{Aڂł́AuMicrosoft SQL ServeriȉASQL ServerjvŎgp\ȓIǗr[ɂāATvo͓eȂǂЉĂ܂B͓IǗr[usys.dm_operation_statusvɂAAzure SQL DatabaseiSQL DatabasejɑĎsꂽɊւ̏o͂ɂĉ܂BΉo[ẂuAzure SQL DatabasevłB
Tv
@uAzure PortalvuSQL Server Management StudiovASQL DatabaseɑĂ܂܂ȑ{ł܂Busys.dm_operation_statusvSQL DatabaseɑĎsꂽɊւo͂܂B݂́ASQL DatabaseɊւ鑀̂ݏo͂܂B
o͓e
| f[^^ | ||
|---|---|---|
| session_activity_id | uniqueidentifier | ID |
| resource_type | int | 삪sΏۂ̃\[X̎ށB̂ꂩɂȂ @0SQL Database |
| resource_type_desc | nvarchari2048j | 삪sΏۂ̃\[X̎ނ̐B̂ꂩɂȂ @Databasê |
| major_resource_id | sql_variant | 삪sΏۂSQL DatabaseT[o̖O |
| minor_resource_id | sql_variant | gp̂ |
| operation | nvarchari60j | SQL DatabaseɑĎs鑀 |
| state | tinyint | ̏ԁB̂ꂩɂȂ @0ۗ @1s @2 @3s @4 |
| state_desc | nvarchari120j | ̏Ԃ̐B̂ꂩɂȂ @PENDING̓\[X܂̓NH[^p\ɂȂ̂ҋ@ @IN_PROGRESS삪JnAs @COMPLETED삪Ɋ @FAILED삪s @CANCELLED[U[̗vɂđ삪~ |
| percent_complete | int | 삪BLȒlȂꍇ͎̂ꂩɂȂ @0삪JnĂȂ @50s @100삪 |
| error_code | int | s쒆ɔG[R[h |
| error_desc | nvarchari2048j | s쒆ɔG[̐ |
| error_severity | int | s쒆ɔG[̏dxx |
| error_state | int | gp邽߂ɗ\Ă |
| start_time | datetime | 삪Jn_̃^CX^v |
| last_modify_time | datetime | ŌɕύXꂽ_̃^CX^v |
֘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