NGvZbT̃obNOEhWu̎svmFFSQL ServerIǗr[t@Xi40j
uMicrosoft SQL Servervғf[^x[XVXe^pǗ҂ɌAuIǗr[v̊pɂgû߂̃mEnEЉĂ܂B́ANGvZbT̃obNOEhWuɂsv̊mFɂĉ܂B
̋L͉łBo^ijƑSĂ܂B
@{Aڂł́AuMicrosoft SQL ServeriȉASQL ServerjvŎgp\ȓIǗr[ɂāATvo͓eȂǂЉĂ܂B͓IǗr[usys.dm_exec_background_job_queue_statsv́ANGvZbT̃obNOEhWuɂsv̊mFɂĉ܂BΉo[ẂASQL Server 2008ȍ~łB
Tv
@usys.dm_exec_background_job_queue_statsvIǗr[ł́ANGvZbT̃obNOEhWu̎svo͂ł܂BuSQL Server 2019 CTP2vł́ANGvZbT̃obNOhWuɂ́Av̔XV݂̂Y܂B̂߁A̓IǗr[gp邱ƂŁAv̔XV̎svo͂ł܂B
o͓e
@1ŝݏo͂܂B
| f[^^ | ||
|---|---|---|
| queue_max_len | int | L[̍ő咷 |
| enqueued_count | int | L[ɐɑMꂽv̐ |
| started_count | int | sJnv̐ |
| ended_count | int | ܂͎ŝǂ炩ɏꂽv̐ |
| failed_lock_count | int | bN̋܂̓fbhbN̂߂Ɏsv̐ |
| failed_other_count | int | ̗̑RŎsv̐ |
| failed_giveup_count | int | Ďs̐ɒB߂Ɏsv̐ |
| enqueue_failed_full_count | int | L[ς̂߁AGL[̎sɎs |
| enqueue_failed_duplicate_count | int | dGL[̎s̐ |
| elapsed_avg_ms | int | v̕όoߎԁi~bPʁj |
| elapsed_max_ms | int | v̍Œoߎԁi~bPʁj |
@f[^x[Xœv̔XVLĂȂԂŁAusys.dm_exec_background_job_queue_statsvIǗr[o͂Ă݂܂i}1jB
@ɉobNOEhWusĂȂԂł1so͂܂ASĂ̗u0vƏo͂܂BɁAf[^x[Xœv̔XVL܂i}2jB
}2@uT-SQLvŃf[^x[X̓v̔XVLƂ@v̔XVLf[^x[X̃e[uŁAvXV悤Ƀf[^̕ύXʂɍs܂BvXV邽߂́uSELECTvNGsAvXVꂽƂmF܂i}3jB
}3@v̍XVAvXVꂽƂ@v̔XVsꂽ߁Ausys.dm_exec_background_job_queue_statsvIǗr[mFƁAv̔XV̎sAόoߎԂmFł܂i}4jB
@ustarted_countv̒l瓝v̔XVsꂽAuelapsed_avg_msv̒lXVɗvώԂmFł܂B
@̃f[^x[X̃e[ułv̔XVsāi}5jAusys.dm_exec_background_job_queue_statsvIǗr[o͂܂i}6jB
}5@̃f[^x[X̃e[uœvXVƂ
@o͍s悤ȂƂ͂ȂA1ŝ݂o͂܂BSẴobNOEhWu킹sv̂߁AvƂ̏͊mFł܂łB܂ASQL ServerT[rX̍ċNɂÁu0vɃZbg悤łB
{TipśAuWindows Server 2019vɁuSQL Server 2019 CTP2vCXg[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