??? waittype ?????? lastwaittype ?? ?????? master.dbo.sysprocesses ?? SQL Server 2000 ? SQL Server 2005

?????? ????????? ?????? ?????????
???? ???????: 822101 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? master.dbo.sysprocesses ?? Microsoft SQL Server 2000 ? SQL Server 2005 ?? ???? ???? ????? ??? ??????? ??? ????? ?????? ?????? ?????? (SPID) ???? ??? ??????? ??? ???? SQL.

??? ??? ?????? SQL Server 2005 ? ????? ????? ?????? ??? ??? ?????? ???????? ????? ????? ??????? sys.sysprocesses.

???? waittype ? ?????? lastwaittype ?????? waittime ? ???? waitresource ?? ???? ?????? master.dbo.sysprocesses ???? ??????? ??? ??????? ???? ?? ?????? ????????.

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

??????? ????

????? ?????? ?????? master.dbo.sysprocesses ??????? ?? ????? ???????? ???????? ?????? ?? ???? SQL Server ??? ??????? ??????? ???? ????? ??? ????? ?????? ?????? ???????? ?????????? ??????? ?????? "?" ????? ???:
  • waittype: ??? waittype ???? ????? ????? ?????. ???? ?????? ?? ??? waittype ??? ??? ???? ?? ?????? ???????.
  • lastwaittype: ??? lastwaittype ????? ????? ????? waittype. ???? ????? lastwaittype ??? waittype ?????? ?? waittype ?????? SPID. ??? ???? ???? ?????? waittype SPID 0x0000 ?? ??? ?????? SPID ?????? ??? ?? ????. ?? ??? ??????? ???? ?????? lastwaittype ??? waittype ??????? ???? ????? SPID. ??? ???? ??? ???? ???? ?????? waittype SPID ??? ????? ????? ?? ???? lastwaittype ??????? waittype SPID ???????. ???? ??? ????? ??? ???? ???????? ??????? ?? SPID.

    ?????? waittype UMSTHREAD ??????? ??? ???????. ???? ??? UMSTHREAD ?? ?????? "???? waittypes" ?????? ??? ?????? ?? ????????.
  • waittime: ???? ???? waittime ??? ?????? ????? ?? ?? ?????? SPID ?? waittype ??????.
  • waitresource: ???? ???? waitresource ???? ??????? ????? ??? ???? ???? ???? ?? ?????? SPID.
??? ??????? ???? ??? ?? ??? ??????? ??? waittypes ???? ??? ????? ?????? SQL Server ???? ???? ???? ????? ?? ???? ?????? master.dbo.sysprocesses.

waittypes LOCK

???? ?????? ?????? waittypes LOCK ?? ???? ?????? master.dbo.sysprocesses ?? SQL Server 2000 ? SQL Server 2005.
?? ??? ??????????? ??? ??????
LastwaittypeWaittype???
lck_m_sch_s0x01??????? ??????
lck_m_sch_m0x02????? ??????
lck_m_s0x03??????
lck_m_u0x04???????
lck_m_x0x05???
lck_m_is0x06?????? ???
lck_m_iu0x07????? ???
lck_m_ix0x08????? ??? ???
lck_m_siu0x09?????? ??? ??????
lck_m_six0x0a?????? ??? ???
lck_m_uix0x0b??????? ??? ???
lck_m_bu0x0c????? ?????
lck_m_rs_s0x0d???? ?????? ????????
lck_m_rs_u0x0e???? ?????? ???????
lck_m_ri_nl0x0F???? ????? NULL
lck_m_ri_s0x10???????? ????? ????
lck_m_ri_u0x11???? ????? ???????
lck_m_ri_x0x12???? ????? ???
lck_m_rx_s0x13???????? ???? ??????
lck_m_rx_u0x14???? ???? ???????
lck_m_rx_x0x15???? ???? ????
????? ?? ????????? ??? ????? LOCK ???? ??? ????? ?? SQL Server 2000 ? SQL Server 2005 ???? ???????? ??????? ?? "??? SQL Server ???????":
  • ??? ??????? ?? SQL Server
  • ????? ???????
???????? ??? ???? ?? ???? ?????? SPID waittypes LOCK ?????? ???????? ?? ?????? waittime ????? ?? ???? ?????? master.dbo.sysprocesses ???? ??? ?? ???? ??????? ??????? ???????? ??? ???? ?? SQL Server.

????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
224453??? ??? ????? ??? 2000 ?? SQL Server 7.0

????? waittypes

????? ???? ?????? ?????? ???? ?????. ???? ??????? ??????? ??????? ???????? ?? latches:
  • ????? Non-?????? ?????? (Non-BUF): latches ??? ?????? ?????? ?????? ????? ?????? ????? ???????? ?? ??????? ?? ????? ??????? re-entrancy ????? ??? ??????? ???????. ???? ??????? ??? latches ??? ????? ???? ?? ??? ????????? ??????? ?????? ??? ????? ?????? ??????.
  • ????? "?????? ??????" (BUF): ??? ??????? latches ?????? ?????? ??????? ???? ??? BUF ????? ?????? ????? ???????? ???????? ???. ??? ?????? ?????? ????????? ???? ????? ???????? ???? ????? ????? ????? ???????? ??? ??? ?? ???? ?????? ???? (????? ????? ???? ?? ????? ????? ???? ????? ??? ???? ??????). ?? ??? ???????? ??? latches ???? ??????. ??? ?????? ????? ?? ?????? master.dbo.sysprocesses ?????? waittypes PAGELATCH.

    ????? ?? ????????? ??? ??? ??????? ???????? ????? ????? BUF ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
    328551FIX: ??????? ????? ????? ?????? tempdp
  • ????? IO: latches IO ?? ?????? ????? latches BUF ????????? ????? ???? ?????? ?????? "?" ???? ???????? ??????? "??" ???? ???? ?? ??? IO ???????. ??? ??????? waittypes PAGEIOLATCH ??????? ??? ????? ??? ??????? ??????? waittime ???? ?? ??? waittypes ?????? ?????? ?????? ?????/????? ?????.
???? ?????? ?????? waittypes ????? ???????? ???? ?? ????? ?? ???? ?????? master.dbo.sysprocesses ?? SQL Server 2000 ? SQL Server 2005.
?? ??? ??????????? ??? ??????
LastwaittypeWaittype???
latch_nl0x400????? ?????
latch_kp0x401???????? ?????
latch_sh0x402????? ????????
latch_up0x403????? ???????
latch_ex0x404????? ???
latch_dt0x405????? ?????
pagelatch_nl0x410????? ???? ?????? ?????? ??????
pagelatch_kp0x411???????? ????? ???? ?????? ??????
pagelatch_sh0x412?????? ????? ???? ?????? ??????
pagelatch_up0x413????? ????? ???? ?????? ??????
pagelatch_ex0x414????? ???? ?????? ?????? ?????
pagelatch_dt0x415????? ????? ???? ?????? ??????
pageiolatch_nl0x420????? ?????? I/O ?????? ?????? ??????
pageiolatch_kp0x421???????? ????? ?????? I/O ?????? ??????
pageiolatch_sh0x422?????? ????? ?????? I/O ?????? ??????
pageiolatch_up0x423????? ????? ?????? I/O ?????? ??????
pageiolatch_ex0x424????? I/O ???? ?????? ?????? ?????
pageiolatch_dt0x425????? ????? ?????? I/O ?????? ??????


??? ????? ???? ?? SQL Server 2000 ?????? ????? ?????? SP4 ? ?????? waitresource ?????? ?????? Buf ???? latches ? Latch_XX ?? latches ???????? ????? ???????? ?? ?????? ??????. ??? SQL Server 2000 ?????? ????? ?????? SP4 ? ??? ???? ??? ????? ?????? ??? latches buf ???? ?? ??? ???????? ??? ?????? ?? ??????? invasive ??? userdump. ??? ?? ??? ??? ?? waittype ?? ?? waitresource ???????? waittime. ???? waittime ??????? ????? ?? ?? ?????? ???? ???????.
?? ??? ??????????? ??? ??????
Waitresource?????????? ??????? ????????
FCB fgcb_alloc??? ????? latches Latch_XX ??? ????? ??? ????? ????? ?? ???? ???? ??? ??? ????? ?? ???????. ??? ????? ????? ?? latches ????? ?????? ??????? ??? ????? ??? ? ????? ??? ?? ????? ??????? ?? ?????? ??? ????? ?? ????? ?? ????? ???.????? ?? ??? ??? ?? ????? ??? ????? ?? ????? ???. ????? ?? SQL Server 2000 ?????? ????? ?????? SP4 ?????? Autogrow ???? ????? ?? errorlog ??? ??????? ???? ?? 30 ?????. ????? ?????? ??? ?? ??? ??????? ?????? Autogrow ?? ???? ???????? ?? ??? ???? ??????? ??? prudent ????? ????? ???? ??? ??????? ?? ????? ??? ?????. ????? ????? ????? ?????? autogrow ?????????? 10 ??????? ??? ??? ????. ?? ???? ??????? Autoshrink ?? ???????. ?? ???? ??????? ???????? ?? ??? filegroup ????? ????? ????? ?????? ?? ?????? ???????. ????? ????? ?????? ?? ??????? ?? ??? filegroup.
TRACE_IO_SYNC TRACE_CONTROLLER ?????? ??? ?????? ??? latches Latch_XX ?????? ???????? ?? ?????? ???? ???? ????? ???????. ????? ?????? Sychronization ??? ????? ????? ???? ?????? ? ????? ?????? ?????. ????? ?? ?????? ???? ????? ??????? ???? ??? ???????. ???? ???? ????? ???? ?? ???? ???? ????? ??????? ?? ??? ?????. ??? ??? ????? ???? ???? ????? ??????? ??? ????? ?????? ?? ??? ????? ???????. ???????? ??? ???? ????? ??????? ????????? ?????? ?? ???? ??????? SQL ???? ?????? ?????.
SELECT * FROM 
::fn_trace_getinfo(NULL)
parallel_page_supplier??? ??????? ??? latches Latch_XX ?????? ??????? ????? ????????? ??????. ???? ??? ????? ??? ????????? ??? ??????? ?? ??? ????? ??? ???? ?????????.????? ????????? ??? ??? ?????? waittime ???? ????? ????? ????????? ???? ???.
ides??? ??????? waitresource ????? IDES ??? ??? ???? PFS ????? ?? ??????? ????? ?????? ??? ????? ?????? PFS ????? ?????? ????? deallocations ???????. ??? ??????? ??? ????? ????? ????? ??? ????? ????? ????? ??? ???? ?????.????? ?? ??? ??? ???? ???? ?????? ???????? ??? ??????.

waittypes ??????

???? ?????? ?????? waittypes ?????? ???? ?? ????? ?? ???? ?????? master.dbo.sysprocesses ?? SQL Server 2000 ? SQL Server 2005.
?? ??? ??????????? ??? ??????
LastwaittypeWaittype???
??? ??????0x20???? ??? waittype ??????? ??? ???? SPID ??? ?? ???? ????? ?????? ??????? ??????? ???? ?????? ?? lazywrites ?? ???? ?????? ?? ????? ?????? ???? ????? ??????? ?? ???? ??????.
io_completion0x21???? ??? waittype ??? ?????? SPID ????? I/O ??????. ??? ?????? ??? waittype ?? SPID ?? ???? ?????? sysprocesses ??? ????? ???????? ????? ???????? ?????? ?????? ?????? ?????? ???? ????? ??????? ???? ????? ??? ?????? fn_virtualfilestats ????? SHOWPLAN ?????? ??? ????????? ???? ?????? ?? SPID. ????? ????? ??? waittype ?????? ?????? ??????? I/O ?????? ?? ?????? I/O ??? ?????? ????? ????. ????? ????? ????? I/O ???????? ??????? ? ???? ?? ??? ????????? ??? ???? ???? ???? ?? ??? ???????.
async_io_completion0x22???? ??? waittype ??? ?????? SPID ????? ?????/????? ??? ?????? ??????. ??? waittype IO_COMPLETION ???? waittype ??? ????? ??? I/O ??????. ?? ??? ??? waittype SPID ????? ?????? I/O-???? ??????? ????? ????? ??? ????? ????????? "??" ????? ????? ?????? "?" ALTER ????? ?????? "??" autogrow ????? ????????. ?? ???? ??? waittype ????? ??? ???????? ?????.
resource_semaphore0x40???? ??? waittype ??? ?????? SPID ??? ????. ???? ???????? SPID "?????? ??? ??????? ????? ?? ????? ??????? ????? ????? ?????????" ???? ???. ?? ???? ??? waittype ????? ??? ?? ??????? ????? ????? ?? ????? ?????? ?? ???? ?????? ??????.
dtc0x41???? ??? waittype ??? ?????? SPID ??? ???? ????????? ??????? Microsoft ???? (MS DTC).
oledb0x42???? ??? waittype ??? ?? SPID ??? ??? ???? ??????? ???? OLE DB ??????? ?????? ?????? ???????? ????????. ?? ???? ??? waittype ????? ??? ?????? SPID ????????? ????????? ?? ??? "??" ???? ????? ????????? "?????? ???????? ????????. ?? ???? ?????? SPID ????? INSERT ????? ????? ??????? ?? ????????? ????? ?????? ????? ???????? ????????.

??? ??????? waittype OLEDB ??????? ?????? ?????? ???????? ????? ??? ?? ??? ???: ?????? ????????? ?????? ?? ????????? ????? ?? ?? ????, ??????? INSERT ????? ????? ? ?????? ???? ????? ??????? ?????? ?? materialization ??????? ??????? ??? ???? sysprocesses ? ???? ??? ? CHECKDB DBCC.
resource_queue0x44??? ???? ? ???? ? ????? ?????? ??????? ??????? ?? SQL Server.
async_diskpool_lock0x45?? ????? ??? waittype ????? ?????? I/O-???? ??????? ????? ????? ??? ????? ?? ????? ?? ????? ??? ????? ??????.
umsthread0x46???? ??? waittype ??? ???? ???? ?? ????? ???? ???? ???? ?? ?????? ????? worker ?????? ????? ?????. ??? ??? ??? 0x0046 ???? ?????? waittypes ??????? SPID ?????? ???? ?????? ???? ???? ??? ?? ?????? ?????? ???? ?????? ????? worker ????????. ???? ?? ?????? waittime ????? ?? 0 ?? ??? waittype UMSTHREAD ?? ????? ?????? lastwaittype ??? waittype ?????? ????? ?? UMSTHREAD."
writelog0x81???? ??? waittype ??? ?????? SPID ??? ???????/????? ??? ?????? ??????. ?? ???? ??? waittype ????? ??? ?????? ?? ??? ??????.
pss_child
?????
cxpacket
0x101
0x200
0x208
waittypes ??? ???? ???????? ?? ????? ????????? ??????. ???? ??? waittypes ?? ????? ?????? ?????? ?? ??? ????? ?????? SPID.
pagesupp0x209????? ??? waittype ??? ???????? ???? ??? ?????? ????? ??????? ???????? ?? ????? ?????? ???????? ?????? ?? ??? ??????.
??? ??????0x20C???? ??? waittype ???????? SPID ?? ???????? ???? ????? ????? ?????? ???? ???????? ??? ??????. sp_configure ? cursorthreshold ? ?? ???? ????? ??????? ????? ??? ????? ??? ???? ???? ??? ??????.
dbtable0x202???? ??? waittype ??? ?????? ???? ????? ?????? ???? ??????, ??? ???? ????? ??? ?????? checkpointing ????? ????????.
ec0x203???? ??? waittype ??? ?????? SPID ?????? ??? ???? ???????.
tempobj0x204???? ??? waittype ??? ?????? SPID ????? ???? ???? ?? ???? ???.
xactlockinfo0x205???? ??? waittype ??? ?????? SPID ?????? ????? ??? ????? ??????? ?????? ??.
logmgr0x206??????? ????? ????? SPID ????? ????? ????? ?????? ??? waittype ????????? ????? ????? I/O ??? ?????? ????? ??????.
cmemthread0x207???? ??? waittype ??? ?????? SPID ?????? ??? ???? ????? ???? ??????? - ?????. ??????? ???? ?? ????? ?????????? ????? ?? ????? ??????? ?? ???? ??????? ?? SPID ???? ????? ????? ?????? ????? ?? ????? ?? waittype CMEMTHREAD ????? ??? ?????? SPID.

?? ????? waittype ??? ?? ?????? ?? ????? ?????????. ??? ???? ??? ????? ????? ??? waittype ??? ??? ????? ??????? ??? ????? ????? ?? ???? ????? ?? ?????? ?? ??????? ?????? ??? ???? SQL Server. ????? ?????? ??? ?????? ?????? ????? ???????? ???? ??? ?? ??? ??????? ?? ??????? ?? ????? ??????? ?????? ??????? ??? ???? ???? parameterizing ??????????? ???? ???? ????? ????????? ??????????? ?? ???????? ????????? ??????? ?????? ???????.
????? ???????0x20A???? ??? waittype ??? ????? ??? SHUTDOWN ?????? SPID ? ??? ?? ?????? SPID ????????? ????? ??????.
waitfor0x20B???? ??? waittype ???? SPID ???? WAITFOR ????? Transact-SQL ?????.
networkio0x800???? ??? waittype ??? ?????? SPID ????? ?????? ????? ???????? ??? ?? ????? SPID ????? ?????? ?? ??????? ??? ????? ??????.

?????

????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
244455????? waittype sysprocesses ????? lastwaittype SQL Server 7.0
?????? ??? ??????? ?????? ??? ???? ?????? master.dbo.sysprocesses ?? SQL Server 2000 ?? ?????? ???? Microsoft ?????? ??? ?????:
http://msdn2.microsoft.com/en-us/library/aa260456(SQL.80).aspx
????? ?? ????????? ??? latches ?? SQL Server 2000 ?? ?????? ???? Microsoft ?????? ??? ?????:
http://msdn2.microsoft.com/en-us/library/aa224727(SQL.80).aspx

???????

???? ???????: 822101 - ????? ??? ??????: 30/???? ??????/1428 - ??????: 8.4
????? ???
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Workgroup Edition
????? ??????: 
kbmt kbsystemdata kbfield kbdatabase kbinfo KB822101 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????822101

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

 

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