SQL выжирает все процессорное время, как решить проблему

[sergeypp]

Цитата:

Сообщение от Vadik

- select @@version

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright © 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: )

Цитата:

Сообщение от Vadik

- dbcc sqlperf(waitstats)

MISCELLANEOUS 1041.0 0.0 0.0
LCK_M_SCH_S 0.0 0.0 0.0
LCK_M_SCH_M 0.0 0.0 0.0
LCK_M_S 2286.0 2.7653155E+8 8850.0
LCK_M_U 4545.0 7.503088E+8 21065.0
LCK_M_X 1055.0 145098.0 2972.0
LCK_M_IS 2554.0 1.4965117E+8 6690.0
LCK_M_IU 18.0 45905.0 189.0
LCK_M_IX 1970.0 6576640.0 7154.0
LCK_M_SIU 0.0 0.0 0.0
LCK_M_SIX 0.0 0.0 0.0
LCK_M_UIX 0.0 0.0 0.0
LCK_M_BU 0.0 0.0 0.0
LCK_M_RS_S 0.0 0.0 0.0
LCK_M_RS_U 0.0 0.0 0.0
LCK_M_RIn_NL 0.0 0.0 0.0
LCK_M_RIn_S 0.0 0.0 0.0
LCK_M_RIn_U 0.0 0.0 0.0
LCK_M_RIn_X 0.0 0.0 0.0
LCK_M_RX_S 0.0 0.0 0.0
LCK_M_RX_U 0.0 0.0 0.0
LCK_M_RX_X 0.0 0.0 0.0
SLEEP 434355.0 1.0797746E+8 1.0705312E+8
IO_COMPLETION 402440.0 1513840.0 10557.0
ASYNC_IO_COMPLETION 6.0 407.0 0.0
RESOURCE_SEMAPHORE 102.0 16284.0 547.0
DTC 0.0 0.0 0.0
OLEDB 633.0 6093.0 388179.0
FAILPOINT 0.0 0.0 0.0
RESOURCE_QUEUE 2501997.0 3.1917923E+8 1.0976838E+8
ASYNC_DISKPOOL_LOCK 68.0 0.0 0.0
UMS_THREAD 0.0 0.0 0.0
PIPELINE_INDEX_STAT 51.0 68938.0 66298.0
PIPELINE_LOG 0.0 0.0 0.0
PIPELINE_VLM 0.0 0.0 0.0
WRITELOG 1291828.0 9660308.0 2408510.0
PSS_CHILD 0.0 0.0 0.0
EXCHANGE 25083.0 95350.0 8576.0
XCB 0.0 0.0 0.0
DBTABLE 0.0 0.0 0.0
EC 0.0 0.0 0.0
TEMPOBJ 0.0 0.0 0.0
XACTLOCKINFO 0.0 0.0 0.0
LOGMGR 0.0 0.0 0.0
CMEMTHREAD 323446.0 126134.0 117435.0
CXPACKET 1747199.0 2.8727779E+8 3401461.0
PAGESUPP 161337.0 489237.0 31173.0
SHUTDOWN 0.0 0.0 0.0
WAITFOR 0.0 0.0 0.0
CURSOR 0.0 0.0 0.0
EXECSYNC 0.0 0.0 0.0
LATCH_NL 0.0 0.0 0.0
LATCH_KP 0.0 0.0 0.0
LATCH_SH 8.0 16.0 16.0
LATCH_UP 737.0 3979684.0 1235.0
LATCH_EX 2.4667112E+7 5.0603392E+7 1.0521914E+7
LATCH_DT 0.0 0.0 0.0
PAGELATCH_NL 0.0 0.0 0.0
PAGELATCH_KP 141.0 109.0 109.0
PAGELATCH_SH 29443.0 111637.0 38758.0
PAGELATCH_UP 28371.0 232737.0 41049.0
PAGELATCH_EX 452773.0 718784.0 586266.0
PAGELATCH_DT 0.0 0.0 0.0
PAGEIOLATCH_NL 0.0 0.0 0.0
PAGEIOLATCH_KP 0.0 0.0 0.0
PAGEIOLATCH_SH 8225469.0 6.0121584E+7 399283.0
PAGEIOLATCH_UP 1053.0 13902.0 157.0
PAGEIOLATCH_EX 448250.0 4389920.0 29984.0
PAGEIOLATCH_DT 0.0 0.0 0.0
TRAN_MARK_NL 0.0 0.0 0.0
TRAN_MARK_KP 0.0 0.0 0.0
TRAN_MARK_SH 0.0 0.0 0.0
TRAN_MARK_UP 0.0 0.0 0.0
TRAN_MARK_EX 0.0 0.0 0.0
TRAN_MARK_DT 0.0 0.0 0.0
NETWORKIO 127386.0 1005379.0 0.0
Total 4.0882756E+7 2.0308475E+9 2.3491994E+8

Цитата:

Сообщение от Vadik

- perfmon по процессору и дискам (disk transfers/sec, average disk queue)

% загр проц - 97
Обращ к диску/сек - 450
Ср. длина очереди - 700