IT咨询服务tsm性能
tsm性能问题
环境描述：
server：win2003+tsm5.5.6
带库：为昆腾 I80
client:aix5300-06-01-0000
tsm:client 5.5.4+lanfree 5.5.5.0
oracle:9208
由于TSM的版本原因，lanfree不能用rmt设备，使用的是mt设备。
客户端输出(aix)：
tsmdlst
IBM TIVOLI STORAGE MANAGER by IBM
Device List Utility Program for AIX
Licensed Materials - Property of IBM
(C) Copyright IBM Corporation 2009. All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corporation.
TSM Device Name Vendor Product ID Firmware World Wide Name Serial Number
--------------- -------- ---------------- -------- ----------------------- ----------------------
/dev/lb0 QUANTUM Scalar i40-i80 135G N/A XXXXXXXXXXXXXXXXXXX
TSM Device Name Vendor Product ID Firmware World Wide Name Serial Number
--------------- -------- ---------------- -------- ----------------------- ----------------------
/dev/mt0 HP Ultrium 5-SCSI Y59Z XXXXXXXXXXXXXXXXXXXXXXX XXXXXX
/dev/mt1 HP Ultrium 5-SCSI Y59Z XXXXXXXXXXXXXXXXXXXXXXX XXXXXX
Error opening /dev/mt2: Device busy
/dev/mt3 HP Ultrium 5-SCSI Y59Z XXXXXXXXXXXXXXXXXXXXXXX XXXXXX
o Library configuration information has been saved in lbinfo
o Tape drive configuration information has been saved in mtinfo
LANFREE的定义
SOURCE_TYPE DESTINATION_NAME DESTINATION_TYPE LIBRARY_NAME DEVICE
--------------- ------------------ ---------------- ------------------ ------------------
SERVER DRIVER1 DRIVE BJ-I80 /dev/mt2
SERVER DRIVER2 DRIVE BJ-I80 /dev/mt3
SERVER DRIVER3 DRIVE BJ-I80 /dev/mt1
SERVER DRIVER4 DRIVE BJ-I80 /dev/mt0
此环境为B机，A机为生产机，环境相同，只是AIXOS的版本略高，但是都是5.3的。
由A机备份，恢复至B机
下面的输出是我在tsm server上通过TSM>STORAGEAGENT:INST BEGIN/INST END截取的。
lanfreede 连接方式均改为sharedmem
Sess Comm. Sess Wait Bytes Bytes Sess Platform
Number Method State Time Sent Recvd Type
------ ------ ------ ------ ------- ------- ----- --------
1 Tcp/Ip IdleW 8 S 804 2.0 K Serv- Windows
er
3 Tcp/Ip IdleW 0 S 35.2 K 256 Serv- Windows
er
4 Tcp/Ip IdleW 0 S 75.1 K 84.7 K Serv- Windows
er
7 ShMem SendW 0 S 100.8 G 245 Node TDP Ora-
cle AIX
8 Tcp/Ip Run 0 S 1.7 K 2.8 K Serv- Windows
er
82 Tcp/Ip Run 0 S 166 230 Admin Windows
现象为：恢复时，观察磁盘的读写，一会比较高，持续个几秒钟时间，就突然0了，然后再持续个几秒钟时间，又突然较高，给人的感觉像是，缓存一部分，写一部分，在缓存一部分，再写一部分。
我想问的是:
1.UNKNOWN是什么？
2.thread wait比较高是由于并发比较大引起的吗？
3.有什么好的解决办法吗？
Instrumentation began 01:42:38.432 ended 01:48:13.322 elapsed 334.890
Thread 4 SmMonitorThread parent=1 01:42:38.432-->01:48:13.322
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 12 0.002 0.000 0.000 0.000 0.0 0
Network Send 12 0.000 0.000 0.000 0.000 0
Unknown 334.887
----------------------------------------------------------------------------
Total 334.890 0.0 0
Thread 11 EventServerReceiverThread parent=8 01:42:38.432-->01:48:13.322
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Send 16 0.000 0.000 0.000 0.000 2
Thread Wait 97 334.890 3.452 0.000 213.016
Unknown 0.000
----------------------------------------------------------------------------
Total 334.890 0.0 2
Thread 12 MmsLibraryPollingThread parent=1 01:42:38.432-->01:48:13.322
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 16 8.989 0.562 0.000 4.491 0.0 0
Network Send 20 0.000 0.000 0.000 0.000 0
Acquire XLatch 6 0.000 0.000 0.000 0.000
Unknown 325.901
----------------------------------------------------------------------------
Total 334.890 0.0 1
Thread 15 AdmServerMonitorThread parent=1 01:42:38.432-->01:48:13.322
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 20 0.004 0.000 0.000 0.000 0.0 0
Network Send 20 0.000 0.000 0.000 0.000 0
Unknown 334.886
----------------------------------------------------------------------------
Total 334.890 0.0 0
Thread 20 SessionThread parent=6 01:42:38.432-->01:48:13.322
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 5 0.001 0.000 0.000 0.000 0.0 0
Network Send 5 0.000 0.000 0.000 0.000 0
Shmem Read 639361 162.687 0.000 0.000 0.044
Shmem Write 639360 2.459 0.000 0.000 0.000
Shmem Copy 639360 7.629 0.000 0.000 0.000
Thread Wait 79920 159.010 0.002 0.000 21.782
Unknown 3.101
----------------------------------------------------------------------------
Total 334.890 0.0 0
Thread 31 AgentThread parent=23 01:42:38.432-->01:48:13.322
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Tape Read 79921 205.606 0.003 0.000 21.804 99509.5 20459776
Thread Wait 79921 128.653 0.002 0.000 0.044
Unknown 0.630
----------------------------------------------------------------------------
Total 334.890 61093.9 20459776
Thread 128 psSessionThread parent=5 01:42:38.432-->01:42:38.434
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 2 0.001 0.001 0.000 0.001 0.0 0
Network Send 2 0.000 0.000 0.000 0.000 0
Acquire XLatch 1 0.000 0.000 0.000 0.000
Thread Wait 4 0.000 0.000 0.000 0.000
Unknown 0.000
----------------------------------------------------------------------------
Total 0.002 0.0 0
Thread 129 SmAdminCommandThread parent=128 01:42:38.432-->01:42:38.432
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 1 0.000 0.000 0.000 0.000 0
Network Send 1 0.000 0.000 0.000 0.000 0
Unknown 0.000
----------------------------------------------------------------------------
Total 0.000
Thread 130 psSessionThread parent=5 01:44:12.125-->01:44:12.137
Session ID 68 ADMIN (Windows)
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 18 0.009 0.001 0.000 0.004 108.0 1
Network Send 17 0.000 0.000 0.000 0.000 2
Acquire XLatch 2 0.000 0.000 0.000 0.000
Thread Wait 184 0.000 0.000 0.000 0.000
Unknown 0.002
----------------------------------------------------------------------------
Total 0.012 242.0 3
Thread 131 SmAdminCommandThread parent=130 01:44:12.131-->01:44:12.132
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 2 0.000 0.000 0.000 0.000 0
Network Send 2 0.000 0.000 0.000 0.000 0
Acquire XLatch 35 0.000 0.000 0.000 0.000
Unknown 0.000
----------------------------------------------------------------------------
Total 0.001 0.0 0
Thread 132 psSessionThread parent=5 01:44:14.534-->01:44:14.546
Session ID 69 ADMIN (Windows)
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 18 0.008 0.000 0.000 0.003 112.7 1
Network Send 17 0.000 0.000 0.000 0.000 2
Acquire XLatch 2 0.000 0.000 0.000 0.000
Thread Wait 184 0.000 0.000 0.000 0.000
Unknown 0.002
----------------------------------------------------------------------------
Total 0.012 249.6 3
Thread 133 SmAdminCommandThread parent=132 01:44:14.541-->01:44:14.542
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 2 0.000 0.000 0.000 0.000 0
Network Send 2 0.000 0.000 0.000 0.000 0
Acquire XLatch 35 0.000 0.000 0.000 0.000
Unknown 0.000
----------------------------------------------------------------------------
Total 0.001 0.0 0
Thread 134 psSessionThread parent=5 01:44:35.828-->01:44:35.840
Session ID 70 ADMIN (Windows)
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 18 0.008 0.000 0.000 0.003 115.0 1
Network Send 17 0.000 0.000 0.000 0.000 2
Acquire XLatch 2 0.000 0.000 0.000 0.000
Thread Wait 184 0.000 0.000 0.000 0.000
Unknown 0.002
----------------------------------------------------------------------------
Total 0.011 250.3 3
Thread 135 SmAdminCommandThread parent=134 01:44:35.834-->01:44:35.836
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 2 0.000 0.000 0.000 0.000 0
Network Send 2 0.000 0.000 0.000 0.000 0
Acquire XLatch 35 0.000 0.000 0.000 0.000
Unknown 0.000
----------------------------------------------------------------------------
Total 0.001 0.0 0
Thread 136 psSessionThread parent=5 01:48:13.314-->01:48:13.322
Session ID 72 ADMIN (Windows)
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 16 0.004 0.000 0.000 0.000 221.9 1
Network Send 15 0.000 0.000 0.000 0.000 1
Acquire XLatch 1 0.000 0.000 0.000 0.000
Thread Wait 1 0.002 0.002 0.002 0.002
Unknown 0.001
----------------------------------------------------------------------------
Total 0.008 244.6 2
Thread 137 SmAdminCommandThread parent=136 01:48:13.320-->01:48:13.322
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 7 0.001 0.000 0.000 0.000 0.0 0
Network Send 7 0.000 0.000 0.000 0.000 0
Acquire XLatch 1 0.000 0.000 0.000 0.000
Unknown 0.000
----------------------------------------------------------------------------
Total 0.002 442.9 1
TOTAL SERVER SUMMARY
Operation Count Tottime Avgtime Maxtime InstTput RealTput Total KB
----------------------------------------------------------------------------
Tape Read 79921 205.606 0.003 21.804 99509.5 61093.9 20459776
Network Recv 139 9.033 0.065 4.491 0.7 0.0 6
Network Send 155 0.002 0.000 0.000 5434.8 0.0 11
Shmem Read 639361 162.687 0.000 0.044
Shmem Write 639360 2.459 0.000 0.000
Shmem Copy 639360 7.629 0.000 0.000
Acquire XLatch 120 0.000 0.000 0.000
Thread Wait 160495 622.559 0.004 213.016
server：win2003+tsm5.5.6
带库：为昆腾 I80
client:aix5300-06-01-0000
tsm:client 5.5.4+lanfree 5.5.5.0
oracle:9208
由于TSM的版本原因，lanfree不能用rmt设备，使用的是mt设备。
客户端输出(aix)：
tsmdlst
IBM TIVOLI STORAGE MANAGER by IBM
Device List Utility Program for AIX
Licensed Materials - Property of IBM
(C) Copyright IBM Corporation 2009. All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corporation.
TSM Device Name Vendor Product ID Firmware World Wide Name Serial Number
--------------- -------- ---------------- -------- ----------------------- ----------------------
/dev/lb0 QUANTUM Scalar i40-i80 135G N/A XXXXXXXXXXXXXXXXXXX
TSM Device Name Vendor Product ID Firmware World Wide Name Serial Number
--------------- -------- ---------------- -------- ----------------------- ----------------------
/dev/mt0 HP Ultrium 5-SCSI Y59Z XXXXXXXXXXXXXXXXXXXXXXX XXXXXX
/dev/mt1 HP Ultrium 5-SCSI Y59Z XXXXXXXXXXXXXXXXXXXXXXX XXXXXX
Error opening /dev/mt2: Device busy
/dev/mt3 HP Ultrium 5-SCSI Y59Z XXXXXXXXXXXXXXXXXXXXXXX XXXXXX
o Library configuration information has been saved in lbinfo
o Tape drive configuration information has been saved in mtinfo
LANFREE的定义
SOURCE_TYPE DESTINATION_NAME DESTINATION_TYPE LIBRARY_NAME DEVICE
--------------- ------------------ ---------------- ------------------ ------------------
SERVER DRIVER1 DRIVE BJ-I80 /dev/mt2
SERVER DRIVER2 DRIVE BJ-I80 /dev/mt3
SERVER DRIVER3 DRIVE BJ-I80 /dev/mt1
SERVER DRIVER4 DRIVE BJ-I80 /dev/mt0
此环境为B机，A机为生产机，环境相同，只是AIXOS的版本略高，但是都是5.3的。
由A机备份，恢复至B机
下面的输出是我在tsm server上通过TSM>STORAGEAGENT:INST BEGIN/INST END截取的。
lanfreede 连接方式均改为sharedmem
Sess Comm. Sess Wait Bytes Bytes Sess Platform
Number Method State Time Sent Recvd Type
------ ------ ------ ------ ------- ------- ----- --------
1 Tcp/Ip IdleW 8 S 804 2.0 K Serv- Windows
er
3 Tcp/Ip IdleW 0 S 35.2 K 256 Serv- Windows
er
4 Tcp/Ip IdleW 0 S 75.1 K 84.7 K Serv- Windows
er
7 ShMem SendW 0 S 100.8 G 245 Node TDP Ora-
cle AIX
8 Tcp/Ip Run 0 S 1.7 K 2.8 K Serv- Windows
er
82 Tcp/Ip Run 0 S 166 230 Admin Windows
现象为：恢复时，观察磁盘的读写，一会比较高，持续个几秒钟时间，就突然0了，然后再持续个几秒钟时间，又突然较高，给人的感觉像是，缓存一部分，写一部分，在缓存一部分，再写一部分。
我想问的是:
1.UNKNOWN是什么？
2.thread wait比较高是由于并发比较大引起的吗？
3.有什么好的解决办法吗？
Instrumentation began 01:42:38.432 ended 01:48:13.322 elapsed 334.890
Thread 4 SmMonitorThread parent=1 01:42:38.432-->01:48:13.322
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 12 0.002 0.000 0.000 0.000 0.0 0
Network Send 12 0.000 0.000 0.000 0.000 0
Unknown 334.887
----------------------------------------------------------------------------
Total 334.890 0.0 0
Thread 11 EventServerReceiverThread parent=8 01:42:38.432-->01:48:13.322
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Send 16 0.000 0.000 0.000 0.000 2
Thread Wait 97 334.890 3.452 0.000 213.016
Unknown 0.000
----------------------------------------------------------------------------
Total 334.890 0.0 2
Thread 12 MmsLibraryPollingThread parent=1 01:42:38.432-->01:48:13.322
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 16 8.989 0.562 0.000 4.491 0.0 0
Network Send 20 0.000 0.000 0.000 0.000 0
Acquire XLatch 6 0.000 0.000 0.000 0.000
Unknown 325.901
----------------------------------------------------------------------------
Total 334.890 0.0 1
Thread 15 AdmServerMonitorThread parent=1 01:42:38.432-->01:48:13.322
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 20 0.004 0.000 0.000 0.000 0.0 0
Network Send 20 0.000 0.000 0.000 0.000 0
Unknown 334.886
----------------------------------------------------------------------------
Total 334.890 0.0 0
Thread 20 SessionThread parent=6 01:42:38.432-->01:48:13.322
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 5 0.001 0.000 0.000 0.000 0.0 0
Network Send 5 0.000 0.000 0.000 0.000 0
Shmem Read 639361 162.687 0.000 0.000 0.044
Shmem Write 639360 2.459 0.000 0.000 0.000
Shmem Copy 639360 7.629 0.000 0.000 0.000
Thread Wait 79920 159.010 0.002 0.000 21.782
Unknown 3.101
----------------------------------------------------------------------------
Total 334.890 0.0 0
Thread 31 AgentThread parent=23 01:42:38.432-->01:48:13.322
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Tape Read 79921 205.606 0.003 0.000 21.804 99509.5 20459776
Thread Wait 79921 128.653 0.002 0.000 0.044
Unknown 0.630
----------------------------------------------------------------------------
Total 334.890 61093.9 20459776
Thread 128 psSessionThread parent=5 01:42:38.432-->01:42:38.434
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 2 0.001 0.001 0.000 0.001 0.0 0
Network Send 2 0.000 0.000 0.000 0.000 0
Acquire XLatch 1 0.000 0.000 0.000 0.000
Thread Wait 4 0.000 0.000 0.000 0.000
Unknown 0.000
----------------------------------------------------------------------------
Total 0.002 0.0 0
Thread 129 SmAdminCommandThread parent=128 01:42:38.432-->01:42:38.432
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 1 0.000 0.000 0.000 0.000 0
Network Send 1 0.000 0.000 0.000 0.000 0
Unknown 0.000
----------------------------------------------------------------------------
Total 0.000
Thread 130 psSessionThread parent=5 01:44:12.125-->01:44:12.137
Session ID 68 ADMIN (Windows)
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 18 0.009 0.001 0.000 0.004 108.0 1
Network Send 17 0.000 0.000 0.000 0.000 2
Acquire XLatch 2 0.000 0.000 0.000 0.000
Thread Wait 184 0.000 0.000 0.000 0.000
Unknown 0.002
----------------------------------------------------------------------------
Total 0.012 242.0 3
Thread 131 SmAdminCommandThread parent=130 01:44:12.131-->01:44:12.132
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 2 0.000 0.000 0.000 0.000 0
Network Send 2 0.000 0.000 0.000 0.000 0
Acquire XLatch 35 0.000 0.000 0.000 0.000
Unknown 0.000
----------------------------------------------------------------------------
Total 0.001 0.0 0
Thread 132 psSessionThread parent=5 01:44:14.534-->01:44:14.546
Session ID 69 ADMIN (Windows)
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 18 0.008 0.000 0.000 0.003 112.7 1
Network Send 17 0.000 0.000 0.000 0.000 2
Acquire XLatch 2 0.000 0.000 0.000 0.000
Thread Wait 184 0.000 0.000 0.000 0.000
Unknown 0.002
----------------------------------------------------------------------------
Total 0.012 249.6 3
Thread 133 SmAdminCommandThread parent=132 01:44:14.541-->01:44:14.542
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 2 0.000 0.000 0.000 0.000 0
Network Send 2 0.000 0.000 0.000 0.000 0
Acquire XLatch 35 0.000 0.000 0.000 0.000
Unknown 0.000
----------------------------------------------------------------------------
Total 0.001 0.0 0
Thread 134 psSessionThread parent=5 01:44:35.828-->01:44:35.840
Session ID 70 ADMIN (Windows)
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 18 0.008 0.000 0.000 0.003 115.0 1
Network Send 17 0.000 0.000 0.000 0.000 2
Acquire XLatch 2 0.000 0.000 0.000 0.000
Thread Wait 184 0.000 0.000 0.000 0.000
Unknown 0.002
----------------------------------------------------------------------------
Total 0.011 250.3 3
Thread 135 SmAdminCommandThread parent=134 01:44:35.834-->01:44:35.836
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 2 0.000 0.000 0.000 0.000 0
Network Send 2 0.000 0.000 0.000 0.000 0
Acquire XLatch 35 0.000 0.000 0.000 0.000
Unknown 0.000
----------------------------------------------------------------------------
Total 0.001 0.0 0
Thread 136 psSessionThread parent=5 01:48:13.314-->01:48:13.322
Session ID 72 ADMIN (Windows)
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 16 0.004 0.000 0.000 0.000 221.9 1
Network Send 15 0.000 0.000 0.000 0.000 1
Acquire XLatch 1 0.000 0.000 0.000 0.000
Thread Wait 1 0.002 0.002 0.002 0.002
Unknown 0.001
----------------------------------------------------------------------------
Total 0.008 244.6 2
Thread 137 SmAdminCommandThread parent=136 01:48:13.320-->01:48:13.322
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 7 0.001 0.000 0.000 0.000 0.0 0
Network Send 7 0.000 0.000 0.000 0.000 0
Acquire XLatch 1 0.000 0.000 0.000 0.000
Unknown 0.000
----------------------------------------------------------------------------
Total 0.002 442.9 1
TOTAL SERVER SUMMARY
Operation Count Tottime Avgtime Maxtime InstTput RealTput Total KB
----------------------------------------------------------------------------
Tape Read 79921 205.606 0.003 21.804 99509.5 61093.9 20459776
Network Recv 139 9.033 0.065 4.491 0.7 0.0 6
Network Send 155 0.002 0.000 0.000 5434.8 0.0 11
Shmem Read 639361 162.687 0.000 0.044
Shmem Write 639360 2.459 0.000 0.000
Shmem Copy 639360 7.629 0.000 0.000
Acquire XLatch 120 0.000 0.000 0.000
Thread Wait 160495 622.559 0.004 213.016
2同行回答
从tsmserver上截取的tsm>inst being/instend
Instrumentation began 01:32:01.812 ended 01:33:47.578 elapsed 105.766
Thread 3 LvmDiskServer (Win Thread ID 11408) 01:32:01.812-->01:33:47.578
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Disk Write 129 0.015 0.000 0.000 0.015 42133.3 632
Thread Wait 130 105.751 0.813 0.000 36.312
Unknown 0.000
----------------------------------------------------------------------------
Total 105.766 6.0 632
Thread 4 LvmDiskServer (Win Thread ID 11428) 01:32:01.812-->01:33:47.578
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Disk Write 12 0.016 0.001 0.000 0.016 4250.0 68
Thread Wait 3 105.750 35.250 0.000 87.828
Unknown 0.000
----------------------------------------------------------------------------
Total 105.766 0.6 68
Thread 16 SessionThread (Win Thread ID 11620) 01:32:01.812-->01:33:47.578
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 9 105.766 11.752 0.000 60.000 0.0 0
Network Send 8 0.000 0.000 0.000 0.000 0
Unknown 0.000
----------------------------------------------------------------------------
Total 105.766 0.0 0
Thread 20 SessionThread (Win Thread ID 11860) 01:32:01.812-->01:33:47.578
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 2 105.766 52.883 47.500 58.266 0.0 0
Network Send 1 0.000 0.000 0.000 0.000 0
Unknown 0.000
----------------------------------------------------------------------------
Total 105.766 0.0 0
Thread 27 SessionThread (Win Thread ID 11572) 01:32:01.812-->01:33:47.578
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 6 105.766 17.628 0.000 51.594 0.0 0
Network Send 5 0.000 0.000 0.000 0.000 0
Unknown 0.000
----------------------------------------------------------------------------
Total 105.766 0.0 0
Thread 41 SessionThread (Win Thread ID 11896) 01:32:01.812-->01:33:47.578
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 53 105.766 1.996 0.000 36.312 0.0 4
Acquire XLatch 26 0.000 0.000 0.000 0.000
Unknown 0.000
----------------------------------------------------------------------------
Total 105.766 0.0 4
Thread 43 SessionThread (Win Thread ID 11900) 01:32:01.812-->01:33:47.578
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 332 105.735 0.318 0.000 20.625 0.1 8
Network Send 127 0.000 0.000 0.000 0.000 9
Acquire Latch 32 0.000 0.000 0.000 0.000
Acquire XLatch 114 0.000 0.000 0.000 0.000
Unknown 0.031
----------------------------------------------------------------------------
Total 105.766 0.2 18
Thread 44 SessionThread (Win Thread ID 11808) 01:32:01.812-->01:33:47.578
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 24 105.515 4.396 0.000 44.359 0.0 0
Network Send 16 0.000 0.000 0.000 0.000 10
Thread Wait 1389 0.235 0.000 0.000 0.047
Unknown 0.016
----------------------------------------------------------------------------
Total 105.766 0.1 10
Thread 45 SessionThread (Win Thread ID 11948) 01:32:01.812-->01:33:47.578
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Send 68 0.000 0.000 0.000 0.000 7
Thread Wait 205 105.750 0.516 0.000 36.312
Unknown 0.016
----------------------------------------------------------------------------
Total 105.766 0.1 7
Thread 47 SessionThread (Win Thread ID 11832) 01:32:01.812-->01:33:47.578
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 7 105.766 15.109 0.000 63.313 0.0 0
Network Send 2 0.000 0.000 0.000 0.000 0
Unknown 0.000
----------------------------------------------------------------------------
Total 105.766 0.0 0
Thread 48 SessionThread (Win Thread ID 11040) 01:32:01.812-->01:32:04.531
Session ID 60 BJ_ZHZG_DB_02_STA (AIX-RS/6000)
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 24 0.000 0.000 0.000 0.000 0
Network Send 8 0.000 0.000 0.000 0.000 0
Acquire Latch 16 0.000 0.000 0.000 0.000
Acquire XLatch 50 0.000 0.000 0.000 0.000
Unknown 2.719
----------------------------------------------------------------------------
Total 2.719 0.0 0
Thread 48 SessionThread (Win Thread ID 1624) 01:32:09.515-->01:33:47.578
Session ID 61 ADMIN (AIX)
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 11 93.516 8.501 0.000 82.016 0.0 0
Network Send 6 0.000 0.000 0.000 0.000 0
Acquire Latch 8 0.000 0.000 0.000 0.000
Acquire XLatch 25 0.000 0.000 0.000 0.000
Thread Wait 20 0.047 0.002 0.000 0.031
Unknown 4.500
----------------------------------------------------------------------------
Total 98.063 0.0 0
Thread 52 ServIssueCmdThread (Win Thread ID 10556) 01:32:25.531-->01:32:25.562
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 10 0.031 0.003 0.000 0.031 0.0 0
Network Send 6 0.000 0.000 0.000 0.000 0
Acquire Latch 8 0.000 0.000 0.000 0.000
Acquire XLatch 32 0.000 0.000 0.000 0.000
Unknown 0.000
----------------------------------------------------------------------------
Total 0.031 0.0 0
Thread 52 ServIssueCmdThread (Win Thread ID 10492) 01:32:46.187-->01:32:46.203
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 10 0.000 0.000 0.000 0.000 1
Network Send 6 0.000 0.000 0.000 0.000 0
Acquire Latch 8 0.000 0.000 0.000 0.000
Acquire XLatch 32 0.000 0.000 0.000 0.000
Unknown 0.016
----------------------------------------------------------------------------
Total 0.016 62.5 1
Thread 52 ServIssueCmdThread (Win Thread ID 3296) 01:33:22.515-->01:33:22.531
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 10 0.000 0.000 0.000 0.000 1
Network Send 6 0.000 0.000 0.000 0.000 0
Acquire Latch 8 0.000 0.000 0.000 0.000
Acquire XLatch 32 0.000 0.000 0.000 0.000
Unknown 0.016
----------------------------------------------------------------------------
Total 0.016 62.5 1
Thread 52 ServIssueCmdThread (Win Thread ID 3124) 01:33:27.921-->01:33:27.937
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 10 0.000 0.000 0.000 0.000 1
Network Send 6 0.000 0.000 0.000 0.000 0
Acquire Latch 8 0.000 0.000 0.000 0.000
Acquire XLatch 32 0.000 0.000 0.000 0.000
Unknown 0.016
----------------------------------------------------------------------------
Total 0.016 62.5 1
Thread 52 ServIssueCmdThread (Win Thread ID 1516) 01:33:29.640-->01:33:29.656
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 10 0.000 0.000 0.000 0.000 1
Network Send 6 0.000 0.000 0.000 0.000 0
Acquire Latch 8 0.000 0.000 0.000 0.000
Acquire XLatch 32 0.000 0.000 0.000 0.000
Unknown 0.016
----------------------------------------------------------------------------
Total 0.016 62.5 1
Thread 52 ServIssueCmdThread (Win Thread ID 11984) 01:33:30.312-->01:33:30.359
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 10 0.015 0.002 0.000 0.015 66.7 1
Network Send 6 0.000 0.000 0.000 0.000 0
Acquire Latch 8 0.000 0.000 0.000 0.000
Acquire XLatch 32 0.000 0.000 0.000 0.000
Unknown 0.032
----------------------------------------------------------------------------
Total 0.047 21.3 1
Thread 52 ServIssueCmdThread (Win Thread ID 10548) 01:33:30.765-->01:33:30.812
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 10 0.015 0.002 0.000 0.015 66.7 1
Network Send 6 0.000 0.000 0.000 0.000 0
Acquire Latch 8 0.000 0.000 0.000 0.000
Acquire XLatch 32 0.000 0.000 0.000 0.000
Unknown 0.032
----------------------------------------------------------------------------
Total 0.047 21.3 1
Thread 52 ServIssueCmdThread (Win Thread ID 3176) 01:33:31.140-->01:33:31.187
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 10 0.032 0.003 0.000 0.016 31.3 1
Network Send 6 0.000 0.000 0.000 0.000 0
Acquire Latch 8 0.000 0.000 0.000 0.000
Acquire XLatch 32 0.000 0.000 0.000 0.000
Unknown 0.015
----------------------------------------------------------------------------
Total 0.047 21.3 1
TOTAL SERVER SUMMARY
Operation Count Tottime Avgtime Maxtime InstTput RealTput Total KB
----------------------------------------------------------------------------
Disk Write 141 0.031 0.000 0.016 22580.6 6.6 700
Network Recv 548 833.689 1.521 82.016 0.0 0.2 21
Network Send 289 0.000 0.000 0.000 30
Acquire Latch 120 0.000 0.000 0.000
Acquire XLatch 471 0.000 0.000 0.000
Thread Wait 1747 317.533 0.182 87.828
Instrumentation output complete.
最快时2分钟大概恢复了14.3G。收起
Instrumentation began 01:32:01.812 ended 01:33:47.578 elapsed 105.766
Thread 3 LvmDiskServer (Win Thread ID 11408) 01:32:01.812-->01:33:47.578
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Disk Write 129 0.015 0.000 0.000 0.015 42133.3 632
Thread Wait 130 105.751 0.813 0.000 36.312
Unknown 0.000
----------------------------------------------------------------------------
Total 105.766 6.0 632
Thread 4 LvmDiskServer (Win Thread ID 11428) 01:32:01.812-->01:33:47.578
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Disk Write 12 0.016 0.001 0.000 0.016 4250.0 68
Thread Wait 3 105.750 35.250 0.000 87.828
Unknown 0.000
----------------------------------------------------------------------------
Total 105.766 0.6 68
Thread 16 SessionThread (Win Thread ID 11620) 01:32:01.812-->01:33:47.578
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 9 105.766 11.752 0.000 60.000 0.0 0
Network Send 8 0.000 0.000 0.000 0.000 0
Unknown 0.000
----------------------------------------------------------------------------
Total 105.766 0.0 0
Thread 20 SessionThread (Win Thread ID 11860) 01:32:01.812-->01:33:47.578
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 2 105.766 52.883 47.500 58.266 0.0 0
Network Send 1 0.000 0.000 0.000 0.000 0
Unknown 0.000
----------------------------------------------------------------------------
Total 105.766 0.0 0
Thread 27 SessionThread (Win Thread ID 11572) 01:32:01.812-->01:33:47.578
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 6 105.766 17.628 0.000 51.594 0.0 0
Network Send 5 0.000 0.000 0.000 0.000 0
Unknown 0.000
----------------------------------------------------------------------------
Total 105.766 0.0 0
Thread 41 SessionThread (Win Thread ID 11896) 01:32:01.812-->01:33:47.578
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 53 105.766 1.996 0.000 36.312 0.0 4
Acquire XLatch 26 0.000 0.000 0.000 0.000
Unknown 0.000
----------------------------------------------------------------------------
Total 105.766 0.0 4
Thread 43 SessionThread (Win Thread ID 11900) 01:32:01.812-->01:33:47.578
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 332 105.735 0.318 0.000 20.625 0.1 8
Network Send 127 0.000 0.000 0.000 0.000 9
Acquire Latch 32 0.000 0.000 0.000 0.000
Acquire XLatch 114 0.000 0.000 0.000 0.000
Unknown 0.031
----------------------------------------------------------------------------
Total 105.766 0.2 18
Thread 44 SessionThread (Win Thread ID 11808) 01:32:01.812-->01:33:47.578
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 24 105.515 4.396 0.000 44.359 0.0 0
Network Send 16 0.000 0.000 0.000 0.000 10
Thread Wait 1389 0.235 0.000 0.000 0.047
Unknown 0.016
----------------------------------------------------------------------------
Total 105.766 0.1 10
Thread 45 SessionThread (Win Thread ID 11948) 01:32:01.812-->01:33:47.578
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Send 68 0.000 0.000 0.000 0.000 7
Thread Wait 205 105.750 0.516 0.000 36.312
Unknown 0.016
----------------------------------------------------------------------------
Total 105.766 0.1 7
Thread 47 SessionThread (Win Thread ID 11832) 01:32:01.812-->01:33:47.578
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 7 105.766 15.109 0.000 63.313 0.0 0
Network Send 2 0.000 0.000 0.000 0.000 0
Unknown 0.000
----------------------------------------------------------------------------
Total 105.766 0.0 0
Thread 48 SessionThread (Win Thread ID 11040) 01:32:01.812-->01:32:04.531
Session ID 60 BJ_ZHZG_DB_02_STA (AIX-RS/6000)
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 24 0.000 0.000 0.000 0.000 0
Network Send 8 0.000 0.000 0.000 0.000 0
Acquire Latch 16 0.000 0.000 0.000 0.000
Acquire XLatch 50 0.000 0.000 0.000 0.000
Unknown 2.719
----------------------------------------------------------------------------
Total 2.719 0.0 0
Thread 48 SessionThread (Win Thread ID 1624) 01:32:09.515-->01:33:47.578
Session ID 61 ADMIN (AIX)
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 11 93.516 8.501 0.000 82.016 0.0 0
Network Send 6 0.000 0.000 0.000 0.000 0
Acquire Latch 8 0.000 0.000 0.000 0.000
Acquire XLatch 25 0.000 0.000 0.000 0.000
Thread Wait 20 0.047 0.002 0.000 0.031
Unknown 4.500
----------------------------------------------------------------------------
Total 98.063 0.0 0
Thread 52 ServIssueCmdThread (Win Thread ID 10556) 01:32:25.531-->01:32:25.562
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 10 0.031 0.003 0.000 0.031 0.0 0
Network Send 6 0.000 0.000 0.000 0.000 0
Acquire Latch 8 0.000 0.000 0.000 0.000
Acquire XLatch 32 0.000 0.000 0.000 0.000
Unknown 0.000
----------------------------------------------------------------------------
Total 0.031 0.0 0
Thread 52 ServIssueCmdThread (Win Thread ID 10492) 01:32:46.187-->01:32:46.203
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 10 0.000 0.000 0.000 0.000 1
Network Send 6 0.000 0.000 0.000 0.000 0
Acquire Latch 8 0.000 0.000 0.000 0.000
Acquire XLatch 32 0.000 0.000 0.000 0.000
Unknown 0.016
----------------------------------------------------------------------------
Total 0.016 62.5 1
Thread 52 ServIssueCmdThread (Win Thread ID 3296) 01:33:22.515-->01:33:22.531
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 10 0.000 0.000 0.000 0.000 1
Network Send 6 0.000 0.000 0.000 0.000 0
Acquire Latch 8 0.000 0.000 0.000 0.000
Acquire XLatch 32 0.000 0.000 0.000 0.000
Unknown 0.016
----------------------------------------------------------------------------
Total 0.016 62.5 1
Thread 52 ServIssueCmdThread (Win Thread ID 3124) 01:33:27.921-->01:33:27.937
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 10 0.000 0.000 0.000 0.000 1
Network Send 6 0.000 0.000 0.000 0.000 0
Acquire Latch 8 0.000 0.000 0.000 0.000
Acquire XLatch 32 0.000 0.000 0.000 0.000
Unknown 0.016
----------------------------------------------------------------------------
Total 0.016 62.5 1
Thread 52 ServIssueCmdThread (Win Thread ID 1516) 01:33:29.640-->01:33:29.656
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 10 0.000 0.000 0.000 0.000 1
Network Send 6 0.000 0.000 0.000 0.000 0
Acquire Latch 8 0.000 0.000 0.000 0.000
Acquire XLatch 32 0.000 0.000 0.000 0.000
Unknown 0.016
----------------------------------------------------------------------------
Total 0.016 62.5 1
Thread 52 ServIssueCmdThread (Win Thread ID 11984) 01:33:30.312-->01:33:30.359
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 10 0.015 0.002 0.000 0.015 66.7 1
Network Send 6 0.000 0.000 0.000 0.000 0
Acquire Latch 8 0.000 0.000 0.000 0.000
Acquire XLatch 32 0.000 0.000 0.000 0.000
Unknown 0.032
----------------------------------------------------------------------------
Total 0.047 21.3 1
Thread 52 ServIssueCmdThread (Win Thread ID 10548) 01:33:30.765-->01:33:30.812
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 10 0.015 0.002 0.000 0.015 66.7 1
Network Send 6 0.000 0.000 0.000 0.000 0
Acquire Latch 8 0.000 0.000 0.000 0.000
Acquire XLatch 32 0.000 0.000 0.000 0.000
Unknown 0.032
----------------------------------------------------------------------------
Total 0.047 21.3 1
Thread 52 ServIssueCmdThread (Win Thread ID 3176) 01:33:31.140-->01:33:31.187
Operation Count Tottime Avgtime Mintime Maxtime InstTput Total KB
----------------------------------------------------------------------------
Network Recv 10 0.032 0.003 0.000 0.016 31.3 1
Network Send 6 0.000 0.000 0.000 0.000 0
Acquire Latch 8 0.000 0.000 0.000 0.000
Acquire XLatch 32 0.000 0.000 0.000 0.000
Unknown 0.015
----------------------------------------------------------------------------
Total 0.047 21.3 1
TOTAL SERVER SUMMARY
Operation Count Tottime Avgtime Maxtime InstTput RealTput Total KB
----------------------------------------------------------------------------
Disk Write 141 0.031 0.000 0.016 22580.6 6.6 700
Network Recv 548 833.689 1.521 82.016 0.0 0.2 21
Network Send 289 0.000 0.000 0.000 30
Acquire Latch 120 0.000 0.000 0.000
Acquire XLatch 471 0.000 0.000 0.000
Thread Wait 1747 317.533 0.182 87.828
Instrumentation output complete.
最快时2分钟大概恢复了14.3G。收起
浏览1299