Странности в поведении Axapt'ы

[Sergey Petrov_imported]

Цитата:

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

select @@version ?

<{POST_SNAPBACK}>

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: Service Pack 1, v.1433)

Цитата:

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

dbcc sqlperf(waitstats)

<{POST_SNAPBACK}>

Wait Type Requests Wait Time Signal Wait Time
MISCELLANEOUS 20.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 15.0 1486.0 0.0
LCK_M_U 30.0 159266.0 156.0
LCK_M_X 0.0 0.0 0.0
LCK_M_IS 9.0 111967.0 0.0
LCK_M_IU 2.0 5860.0 0.0
LCK_M_IX 18.0 365234.0 0.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 109082.0 4767016.0 4755491.0
IO_COMPLETION 1529.0 16155.0 0.0
ASYNC_IO_COMPLETION 4.0 359.0 0.0
RESOURCE_SEMAPHORE 0.0 0.0 0.0
DTC 0.0 0.0 0.0
OLEDB 3.0 705.0 0.0
FAILPOINT 0.0 0.0 0.0
RESOURCE_QUEUE 139793.0 1.3943909E+7 4742497.0
ASYNC_DISKPOOL_LOCK 33.0 0.0 0.0
UMS_THREAD 0.0 0.0 0.0
PIPELINE_INDEX_STAT 0.0 0.0 0.0
PIPELINE_LOG 0.0 0.0 0.0
PIPELINE_VLM 0.0 0.0 0.0
WRITELOG 75795.0 138961.0 8449.0
PSS_CHILD 0.0 0.0 0.0
EXCHANGE 3.0 0.0 0.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 7260.0 1100.0 1036.0
CXPACKET 39727.0 2993241.0 25708.0
PAGESUPP 594.0 468.0 280.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 0.0 0.0 0.0
LATCH_UP 17.0 219.0 0.0
LATCH_EX 1751914.0 994243.0 199612.0
LATCH_DT 0.0 0.0 0.0
PAGELATCH_NL 0.0 0.0 0.0
PAGELATCH_KP 1.0 0.0 0.0
PAGELATCH_SH 4106.0 2500.0 328.0
PAGELATCH_UP 821.0 2183.0 387.0
PAGELATCH_EX 10914.0 2309.0 1263.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 107398.0 671708.0 2397.0
PAGEIOLATCH_UP 150.0 1172.0 0.0
PAGEIOLATCH_EX 19551.0 180694.0 499.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 63075.0 22649.0 0.0
Total 2331864.0 2.4383404E+7 9738103.0