Sos_scheduler_yield yog dab tsi?
Sos_scheduler_yield yog dab tsi?

Video: Sos_scheduler_yield yog dab tsi?

Video: Sos_scheduler_yield yog dab tsi?
Video: Office Hours: Ask Me Anything About Microsoft SQL Server 2024, Kaum ib hlis
Anonim

SOS_SCHEDULER_YIELD txhais tau hais tias SQL Operating System (SOS) tab tom tos CPU teem sijhawm kom tau txais ntau lub sijhawm, tab sis qhov kev tos no yog me ntsis trickier tshaj qhov ntawd.

Tom qab ntawd, Pageiolatch_ex yog dab tsi?

SQL Server Books online txhais cov SQL tos hom pageiolatch_ex Raws li Tom tshwm sim thaum ib txoj haujlwm tseem tos ntawm lub latch rau qhov tsis nyob hauv qhov kev thov I / O. Qhov kev thov latch yog nyob rau hauv Exclusive hom. Cov hauv paus ntsiab lus feem ntau cuam tshuam nrog disk rau kev nco, nco siab thiab disk IO subsystem teeb meem xws li teeb meem caching.

Tom qab, lo lus nug yog, dab tsi yog hom tos hauv SQL Server? Raws li BOL, muaj peb hom kev tos, uas yog:

  • Cov peev txheej tos. Cov peev txheej tos tshwm sim thaum tus neeg ua haujlwm thov nkag mus rau cov peev txheej uas tsis muaj vim tias cov peev txheej tam sim no siv los ntawm lwm tus neeg ua haujlwm, lossis nws tseem tsis tau muaj.
  • Queue tos.
  • Sab nraud tos.

Tsis tas li ntawd, Lck_m_u yog dab tsi?

LCK_M_U yog tos rau qhov hloov tshiab xauv. Ib yam dab tsi sim hloov tshiab thiab xijpeem nws xav hloov tshiab raug kaw lawm. Pib los ntawm kev txheeb xyuas qhov ua rau qhov thaiv thiab saib seb nws puas tuaj yeem ua kom zoo, tom qab ntawd saib seb qhov twg yog qhov thaiv thiab nws tuaj yeem ua kom zoo li cas.

Async_network_io yog dab tsi?

SQL neeg rau zaub mov tuav cov ntaub ntawv hauv cov khoom tso tawm kom txog thaum nws tau txais kev lees paub los ntawm tus neeg siv khoom tias nws tau siv cov ntaub ntawv ntawd tiav lawm. ASYNC_NETWORK_IO yog qhov qhia tau tias koj daim ntawv thov tus neeg siv khoom tsis tuaj yeem khaws cov ntaub ntawv nws xav tau los ntawm qhov system.

Pom zoo: