?nh ngh?a c?a sysprocesses waittype v lastwaittype c?t cho SQL Server 7.0

D?ch tiu ? D?ch tiu ?
ID c?a bi: 244455 - Xem s?n ph?m m bi ny p d?ng vo.
Bung t?t c? | Thu g?n t?t c?

TM T?T

Cc sysprocesses bn trong SQL Server l m?t b?ng ?o c ch?a thng tin v? my ch? ho?t ?ng qu tr?nh ID (SPID). Cc lastwaittype l?nh v?c m?i trong SQL Server 7.0 v l ?i di?n cho chu?i c?a cc waittype l?nh v?c (?c m?t c?t dnh ring n?i b? nh? phn). N ch? ra waittype cu?i ho?c hi?n t?i c?a m?t d?ch v? SPID. N?u waittype l 0x0000, d?ch v? SPID khng ph?i hi?n ang ch? ?i trn b?t c? i?u g? v gi tr? lastwaittype ch? ra cu?i waittype d?ch v? SPID c kinh nghi?m. N?u waittype l khng, lastwaittype v waittype s? ?c tng ng v ch? ra waitstate hi?n t?i cho d?ch v? SPID.

Bi ny li?t k cc gi tr? c th? lastwaittype, gi tr? lin k?t waittype, v m?t m t? ng?n g?n v? ? ngh?a c?a h?.

THNG TIN THM

Waittypes sau ch? ch? ?i ngy kha ?c ch? r? trong cc M ta c?t. Cc waitresource c?t s? hi?n th? cc ngu?n ti nguyn c? th? d?ch v? SPID l c? g?ng ? kha.

Thu g?n b?ng nyBung r?ng b?ng ny
LastwaittypeWaittypeM ta
LCK_M_SCH_S0x01L?c ? s? ?n ?nh
LCK_M_SCH_M0x02S?a ?i l?c ?
LCK_M_IS0x03M?c ch chia s?
LCK_M_SIU0x04Chia s? ? ?nh ? C?p Nh?t
LCK_M_IS_S0x05M?c ch-chia s?-chia s? (t?m Key Lock)
LCK_M_IX0x06? ?nh ?c quy?n
LCK_M_SIX0x07Chia s? ? ?nh-?c quy?n
LCK_M_S0x08Chia se
LCK_M_U0x09Cp nht
LCK_M_II_NL0x0AM?c ch-Insert-NULL (t?m Key Lock)
LCK_M_II_X0x0B? ?nh chn-m?t ?c quy?n (t?m Key Lock)
LCK_M_IU0x0CM?c ch-Update kha
LCK_M_IS_U0x0DM?c ch chia s? Update (t?m Key Lock)
LCK_M_X0x0E?c quy?n
LCK_M_BU0x0FS? l?ng l?n Update


Waittypes sau ch? ch? ?i ngy m?t ch?t trang ?c xc ?nh trong cc M ta c?t. Cc waitresource c?t s? hi?n th? cc ngu?n ti nguyn m qu tr?nh l c? g?ng ? c ?c m?t ch?t vo. Lastwaittype chu?i s? ch? ra ch? ? ch?t tr?nh ch? ?i. ? bi?t thm chi ti?t trn trang ch?t, xem ch? ? "Latching" trong SQL Server 7.0 sch tr?c tuy?n.

Thu g?n b?ng nyBung r?ng b?ng ny
LastwaittypeWaittypeM ta
PWAIT_LATCH_NL0x400Null ch?t
PWAIT_LATCH_EX0x401?c quy?n ch?t
PWAIT_LATCH_SH0x402Chia s? ch?t
PWAIT_LATCH_UP0x403C?p Nh?t ch?t
PWAIT_PAGELATCH_NL0x410Tr?ng trang ch?t
WAIT_PAGELATCH_EX0x411?c quy?n trang ch?t
WAIT_PAGELATCH_SH0x412Chia s? trang ch?t
PWAIT_PAGELATCH_UP0x413C?p nh?t trang ch?t
PWAIT_PAGEIOLATCH_NL0x420Null ?u vo/?u ra (I/O) trang ch?t
PWAIT_PAGEIOLATCH_EX0x421?c quy?n I/O trang ch?t
PWAIT_PAGEIOLATCH_SH0x422Chia s? I/O trang ch?t
PWAIT_PAGEIOLATCH_UP0x423C?p Nh?t I/O trang ch?t


Cc s? ki?n sau y ch? ra r?ng th?c hi?n k?t n?i ng?i s? d?ng b? ?nh ch? cho ?n khi m?t s? ki?n c? th? x?y ra:

Thu g?n b?ng nyBung r?ng b?ng ny
LastwaittypeWaittypeM ta
PWAIT_RESOURCE_SEMAPHORE0x40Ch? ?i ? c ?c m?t semaphore ti nguyn. ?c s? d?ng ? ?ng b? ha.
PWAIT_DTC0x41Ch? ?i ngy giao d?ch phn b? i?u ph?i vin (DTC).
PWAIT_OLEDB0x42Ch? ?i trn m?t nh cung c?p OLE DB.
PWAIT_WRITELOG0x81Ch? ?i cho Nh?t k? ghi cho m?t giao d?ch ? ?c flushed vo ?a.
PWAIT_PSS_CHILD0x101Ch? ?i trn m?t s?i ?a tr? vo cc con tr? khng ?ng b?.
PWAIT_EXCHANGE0x200Exchange ?ng b? ha cho song song truy v?n ?.
PWAIT_XCB0x201C ?c quy?n truy c?p vo m?t kh?i i?u khi?n giao d?ch.
Giao d?ch ki?m sot kh?i (XCBs) t nhn th?ng v?, nhng c th? ?c chia s? gi?a bu?i khi s? d?ng tnh nng b? rng bu?c phin ho?c c nhi?u phin ch?y nh?p ng? trong giao d?ch DTC cng. Ch? m?t phin duy nh?t c th? c quy?n truy c?p vo XCB t?i m?t th?i i?m. Ny waittype c kh? nng ch? m?t phin ch?y ang ch? XCB trong khi phin h?p khc m ang n?m gi? cc ngu?n ti nguyn XCB ch? ?i trn m?t ngu?n ti nguyn ring bi?t.
PWAIT_DBTABLE0x202Ch? s? d?ng qua tr?m ki?m sot qu tr?nh.
PWAIT_EC0x203Gi?t ch?t m?t k?t n?i subthread ho?c b?i c?nh th?c hi?n.
PWAIT_TEMPOBJ0x204Th? m?t ?i t?ng t?m th?i.
PWAIT_XACTLOCKINFO0x205Ch? ?i ngy ho?t ?ng v?i s? l?ng l?n khi releasing\escalating\transferring kha.
PWAIT_LOGMGR0x206ang ch? ng nh?p nh vn.
PWAIT_CMEMTHREAD0x207Ch? ?i ngy truy c?p vo b? nh? ?i t?ng.
PWAIT_CXPACKET0x208Ch? ?i ngy gi d? li?u ?ng b? ha cho nh i?u hnh trao ?i (song song truy v?n).
PWAIT_PAGESUPP0x209Phin b?n Spinlock trong ch? ? song song truy v?n.
PWAIT_SHUTDOWN0x20ACh? ?i cho d?ch v? SPID ? k?t thc hon thnh tr?c khi t?t my.
PWAIT_WAITFOR0x20BCh? ?i kh?i x?ng b?i m?t l?nh WAITFOR.
PWAIT_CURSOR0x20CCh? ?i cho s?i ?ng b? ha v?i con ch?y khng ?ng b?.

Thu?c tnh

ID c?a bi: 244455 - L?n xem xt sau cng: 21 Thang Tam 2011 - Xem xt l?i: 2.0
p d?ng
  • Microsoft SQL Server 7.0 Standard Edition
T? kha:
kbinfo kbmt KB244455 KbMtvi
My d?ch
QUAN TRONG: Bi vi?t ny ?c d?ch b?ng ph?n m?m d?ch my c?a Microsoft ch? khng ph?i do con ng?i d?ch. Microsoft cung c?p cc bi vi?t do con ng?i d?ch v c? cc bi vi?t do my d?ch ? b?n c th? truy c?p vo t?t c? cc bi vi?t trong C s? Ki?n th?c c?a chng ti b?ng ngn ng? c?a b?n. Tuy nhin, bi vi?t do my d?ch khng ph?i lc no c?ng hon h?o. Lo?i bi vi?t ny c th? ch?a cc sai st v? t? v?ng, c php ho?c ng? php, gi?ng nh m?t ng?i n?c ngoi c th? m?c sai st khi ni ngn ng? c?a b?n. Microsoft khng ch?u trch nhi?m v? b?t k? s? thi?u chnh xc, sai st ho?c thi?t h?i no do vi?c d?ch sai n?i dung ho?c do ho?t ?ng s? d?ng c?a khch hng gy ra. Microsoft c?ng th?ng xuyn c?p nh?t ph?n m?m d?ch my ny.
Nh?p chu?t vo y ? xem b?n ti?ng Anh c?a bi vi?t ny:244455

Cung cp Phan hi

 

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