????? waittype sysprocesses ?????? lastwaittype SQL Server 7.0

?????? ????????? ?????? ?????????
???? ???????: 244455 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

??????

???? sysprocesses ?? SQL Server ???? ????? ????? ??? ??????? ??? ????? ?????? ?????? ?????? (SPID). ????? lastwaittype ??????? ?? SQL Server 7.0 ? ??? ????? ????? ??? waittype (??? ???? ????? ????? ?????). ???? waittype ?????? ?? ?????? SPID. ??? ??? waittype 0x0000 ? SPID ??? ??? ?????? ??? ?? ??? ????? ???? lastwaittype waittype ?????? SPID ????. ??? waittype ??? ???? ???? lastwaittype ? waittype ??? ???? ??????? ????? waitstate ?????? ?? SPID.

???? ??? ??????? ??? lastwaittype ???????? ????? waittype ???????? ???? ????? ??? ??????.

??????? ????

???? waittypes ??????? ??? ?????? ?? ????? ?????? ?? ???? ?????. waitresource ????? ?????? ???? ???? SPID ?????? ?????.

?? ??? ??????????? ??? ??????
LastwaittypeWaittype???
lck_m_sch_s0x01??????? ??????
lck_m_sch_m0x02????? ??????
lck_m_is0x03?????? ???
lck_m_siu0x04?????? ??? ??????
lck_m_is_s0x05??? - ?????? - ?????? (????? ???? ?????)
lck_m_ix0x06????? ??? ???
lck_m_six0x07?????? ??? ???
lck_m_s0x08??????
lck_m_u0x09???????
lck_m_ii_nl0x0A??? - ????? - NULL (????? ???? ?????)
lck_m_ii_x0x0B??? - ????? - ??? (????? ???? ?????)
lck_m_iu0x0C????? ????? ???
lck_m_is_u0x0D????? ?????? ??? (????? ???? ?????)
lck_m_x0x0E???
lck_m_bu0x0F????? ?????


???? waittypes ??????? ??? ?????? ????? ???? ?????? ?? ???? ?????. ????? ?????? waitresource ?????? ???? ????? ??????? ?????? ??? ????? ???. ????? ????? lastwaittype ?? ?????? ??? ????? ???????. ?????? ??? ???? ?? ????????? ??? latches ?????? ???? ??????? "Latching" ?? SQL Server 7.0 ????????.

?? ??? ??????????? ??? ??????
LastwaittypeWaittype???
pwait_latch_nl0x400????? ?????
pwait_latch_ex0x401????? ???
pwait_latch_sh0x402????? ????????
pwait_latch_up0x403????? ???????
pwait_pagelatch_nl0x410????? ???? ?????
wait_pagelatch_ex0x411????? ?????? ???
wait_pagelatch_sh0x412????? ???? ??????
pwait_pagelatch_up0x413????? ?????? ?????
pwait_pageiolatch_nl0x420????? ???????/??????? (I/O) ?????? ?????
pwait_pageiolatch_ex0x421????? ?????? I/O ???
pwait_pageiolatch_sh0x422?????? ????? ?????? I/O
pwait_pageiolatch_up0x423????? ?????? ??????? I/O


??????? ??????? ???? ??? ?? ??? ????? ????? ????? ?????? ????????? ??? ???? ??? ????:

?? ??? ??????????? ??? ??????
LastwaittypeWaittype???
pwait_resource_semaphore0x40?? ?????? ?????? ??? ????? ????. ??????? ???????.
pwait_dtc0x41?????? ???? ????????? ??????? (DTC).
pwait_oledb0x42?????? ???? OLE DB.
pwait_writelog0x81?????? ??? ??????? ??????? ?? ??? ??? ??? ?????.
pwait_pss_child0x101?????? ???? ????? ???? ?? ?????? ??? ?????? ??? ??????.
pwait_exchange0x200????? ?????? ?????? ?????? ??????? ????????? ??????.
pwait_xcb0x201??? ???? ?????? ??? ?? ?????? ??? ???? ???? ??????.
??? ?????? ???????? (XCBs) ?????? ????? ??? ???? ??? ???? ???? ???????? ??? ????? ????? ??? ??????? ???? ???? ???? ?? ???? ????? ???????? DTC ??? ????? ??? ??????. ???? ?? ???? ???? ????? ??? ?????? ??? XCB ?? ?? ???. ???? ??? waittype ??????? ??? ???? ??? ????? ?????? XCB ????? ???? ????? ?????? ???? ????? ?? ?????? ??????? XCB ??? ???? ??????.
pwait_dbtable0x202??????? ?????? ????? ???? ????? ???.
pwait_ec0x203killing subthread ??????? ?? "???? ???????".
pwait_tempobj0x204????? ???? ?????.
pwait_xactlockinfo0x205?? ?????? "????? ????" ??? ????? releasing\escalating\transferring.
pwait_logmgr0x206?????? ??? ??????.
pwait_cmemthread0x207?? ?????? ??? ?????? ??? ???? ???????.
pwait_cxpacket0x208?????? ?????? ??? ???? ????? ????? ????? (??????? ??????).
pwait_pagesupp0x209??? Spinlock ?? ???? ????? ????????? ??????.
pwait_shutdown0x20A????? ??? ???? SPID ?????? ??????? ??? ????? ???????.
pwait_waitfor0x20B???????? ??? ??? WAITFOR.
pwait_cursor0x20C?? ?????? ???? ??????? ??????? ?? ???? ???????? ??? ??????.

???????

???? ???????: 244455 - ????? ??? ??????: 23/???? ?????/1426 - ??????: 2.2
????? ???
  • Microsoft SQL Server 7.0 Standard Edition
????? ??????: 
kbmt kbinfo KB244455 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????244455

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com