Definition of sysprocesses waittype and lastwaittype columns for SQL Server 7.0

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

??????

Thesysprocessestable in SQL Server is a virtual table containing information about active server process IDs (SPIDs). Thelastwaittypefield is new in SQL Server 7.0 and is a string representation of thewaittypefield (which is a reserved internal binary column). It indicates the last or current waittype of a SPID. If the waittype is 0x0000, the SPID is not currently waiting on anything and the lastwaittype value indicates the last waittype the SPID experienced. If the waittype is non-zero, the lastwaittype and waittype will be equivalent and indicate the current waitstate for the SPID.

This article lists the possible lastwaittype values, their associated waittype values, and a brief description of their meaning.

???? ???????

The following waittypes indicate waiting on the lock specified in the?????:?????? Thewaitresourcecolumn will show the specific resource the SPID is attempting to lock.

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
LastwaittypeWaittype?????:
LCK_M_SCH_S0x01Schema stability
LCK_M_SCH_M0x02Schema modification
LCK_M_IS0x03Intent-Share
LCK_M_SIU0x04Shared intent to update
LCK_M_IS_S0x05Intent-Share-Share (Key-Range Lock)
LCK_M_IX0x06Intent-Exclusive
LCK_M_SIX0x07Share-Intent-Exclusive
LCK_M_S0x08Share
LCK_M_U0x09??????
LCK_M_II_NL0x0AIntent-Insert-NULL (Key-Range Lock)
LCK_M_II_X0x0BIntent-Insert-Exclusive (Key-Range Lock)
LCK_M_IU0x0CIntent-Update lock
LCK_M_IS_U0x0DIntent-Share Update (Key-Range Lock)
LCK_M_X0x0EExclusive
LCK_M_BU0x0FBulk Update


The following waittypes indicate waiting on a page latch that is specified in the?????:?????? Thewaitresourcecolumn will show the resource which the process is attempting to acquire a latch on. Lastwaittype ???????? ????? ???? latch ??? ????????? ????????? ?? ??? ??? ????? latches ?? ???? ??????? ?? ??? SQL Server 7.0 ???????? ?????? ??? "Latching" ???? ?? ??????

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
LastwaittypeWaittype?????:
PWAIT_LATCH_NL0x400?? latch
PWAIT_LATCH_EX0x401????? latch
PWAIT_LATCH_SH0x402???? latch
PWAIT_LATCH_UP0x403Latch ?????? ????
PWAIT_PAGELATCH_NL0x410????? ????? latch
WAIT_PAGELATCH_EX0x411????? ????? latch
WAIT_PAGELATCH_SH0x412????? latch ???? ????
PWAIT_PAGELATCH_UP0x413????? latch ?????? ????
PWAIT_PAGEIOLATCH_NL0x420?? ?????/?????? (i/O) ????? latch
PWAIT_PAGEIOLATCH_EX0x421????? i/O ????? latch
PWAIT_PAGEIOLATCH_SH0x422I/O ????? latch ???? ????
PWAIT_PAGEIOLATCH_UP0x423I/O ????? latch ?????? ????


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

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
LastwaittypeWaittype?????:
PWAIT_RESOURCE_SEMAPHORE0x40??? ?????? semaphore ??????? ???? ?? ??? ????????? ?? ??? ??? ?????????????? ?? ??? ????? ???? ???? ???
PWAIT_DTC0x41?????? ?????? Coordinator (DTC) ?? ????????? ?? ??? ???
PWAIT_OLEDB0x42??? OLE DB ??????? ?? ????????? ?? ??? ???
PWAIT_WRITELOG0x81??? ?? ?? ??? ????????? ?????? ?? ???? ?? ??? ??? ????????? ?? ??? ??????? ???? ?? ??? ??????
PWAIT_PSS_CHILD0x101?????????? ????? ???????? ??? ??? ?????? ????? ?? ????????? ?? ??? ???
PWAIT_EXCHANGE0x200???????? ?????? ????? ?? ??? ??? ????????????? ?????? ???
PWAIT_XCB0x201??? ????????? ???????? ????? ???? ?? ??? ????? ??????? ?????
????????? ???????? ????? (XCBs) ?? ???? ?? ??? ????? ?? ???? ???, ????? ?????? ?? ??? ???? ?? ???? ??? ?? ????? ???? ?????? ?? ????? ?? ?? ?? ?? ???? ???? ??? ?? ?? DTC ????????? enlist ????? ???? ??? ??? ???? XCB ?? ????? ?? ?? ??? ??? ?? ????? ???? ?? ?? ?? waittype XCB ?? ??? ??????????? ???? ???? XCB ?????? ?? ?? ??? ?????? ?? ????????? ?? ??? ?? ?? ?? ????? ????? ?? ???? ?? ????? ???? ???
PWAIT_DBTABLE0x202???? ???????? ????????? ?????? ????? ???? ????
PWAIT_EC0x203??????? subthread ?? ???????? ?????? killing ?????
PWAIT_TEMPOBJ0x204?? ?????? ???????? ?? ?????? ?????
PWAIT_XACTLOCKINFO0x205??? ???? ???????? ?? ????????? ???? ?? releasing\escalating\transferring ??????? ???? ???
PWAIT_LOGMGR0x206??? ???? ?? ????????? ?? ??? ???
PWAIT_CMEMTHREAD0x207?????? ???????? ?? ????? ?? ????????? ?? ??? ???
PWAIT_CXPACKET0x208????????? ?? ??? ?? ?? ????? ???????? ?????? (???????? ??????) ?? ??? ??? ??????????? ???
PWAIT_PAGESUPP0x209???????? ?????? ????? ??? Spinlock ????? ?????
PWAIT_SHUTDOWN0x20A?? ???? ???? ?? ???? ??????? ?? ?????? ???? ?? ??? SPID ?? ????????? ?? ??? ???
PWAIT_WAITFOR0x20B????????? WAITFOR ???? ?????? ??????? ?????
PWAIT_CURSOR0x20C?????????? ????? ?? ??? ????? ????????????? ?? ??? ????????? ?? ??? ???

???

???? ID: 244455 - ????? ???????: 02 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft SQL Server 7.0 Standard Edition
??????: 
kbinfo kbmt KB244455 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??: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