请教sybase插入记录慢原因
create table temp_test(Corp_ID varchar(8) not null,Corp_num varchar(8) not null)向上面这个简单的heap表插入1万条记录要将近二分钟，测试时几乎没其它连接执行任务，请大家帮忙分析如此慢的原因，多谢先。
Adaptive Server Enterprise/12.5.4/EBF 13396/P/x86_64/Enterprise Linux/ase1254/2006/64-bit/OPT/Sat May 20 00:15:42 2006
===============================================================================
Sybase Adaptive Server Enterprise System Performance Report
===============================================================================
Server Version: Adaptive Server Enterprise/12.5.4/EBF 13396/P/x86_64/Ent
Run Date: Jun 16, 2012
Sampling Started at: Jun 16, 2012 00:03:03
Sampling Ended at: Jun 16, 2012 00:04:03
Sample Interval: 00:01:00
Sample Mode: Reset Counters
===============================================================================
Kernel Utilization
------------------
Your Runnable Process Search Count is set to 2000
and I/O Polling Process Count is set to 10
Engine Busy Utilization CPU Busy I/O Busy Idle
------------------------ -------- -------- --------
Engine 0 0.0 % 0.0 % 100.0 %
Engine 1 0.0 % 0.8 % 99.2 %
Engine 2 0.0 % 0.2 % 99.8 %
Engine 3 0.0 % 0.2 % 99.8 %
Engine 4 0.5 % 0.7 % 98.8 %
Engine 5 0.0 % 0.0 % 100.0 %
Engine 6 0.0 % 0.0 % 100.0 %
Engine 7 0.0 % 0.0 % 100.0 %
Engine 8 0.0 % 0.0 % 100.0 %
Engine 9 0.0 % 0.0 % 100.0 %
Engine 10 0.0 % 0.0 % 100.0 %
Engine 11 0.0 % 0.0 % 100.0 %
------------------------ -------- -------- --------
Summary Total 0.5 % 1.8 % 1197.7 %
Average 0.0 % 0.2 % 99.8 %
CPU Yields by Engine per sec per xact count% of total
---------------------------------------------------------------------
Engine 0 60.7 62.8 3641 4.7 %
Engine 1 59.6 61.6 3573 4.6 %
Engine 2 220.0 227.6 13200 17.2 %
Engine 3 462.4 478.3 27741 36.1 %
Engine 4 59.4 61.4 3562 4.6 %
Engine 5 60.1 62.1 3603 4.7 %
Engine 6 60.1 62.1 3604 4.7 %
Engine 7 60.0 62.1 3602 4.7 %
Engine 8 60.0 62.1 3602 4.7 %
Engine 9 60.1 62.2 3605 4.7 %
Engine 10 60.1 62.2 3605 4.7 %
Engine 11 60.1 62.2 3606 4.7 %
-----------------------------------------------------------
Total CPU Yields 1282.4 1326.6 76944
Network Checks
Non-Blocking 28420.6 29400.6 1705234 95.7 %
Blocking 1282.2 1326.4 76931 4.3 %
-----------------------------------------------------------
Total Network I/O Checks 29702.8 30727.0 1782165
Avg Net I/Os per Check n/a n/a 0.00019 n/a
Disk I/O Checks
Total Disk I/O Checks 29723.8 30748.8 1783430 n/a
Checks Returning I/O 10876.8 11251.8 652607 36.6 %
Avg Disk I/Os Returned n/a n/a 0.00029 n/a
Tuning Recommendations for Kernel Utilization
---------------------------------------------
- Consider decreasing the 'runnable process search count'
configuration parameter if you require the CPU's on
the machine to be used for other applications.
===============================================================================
Worker Process Management
-------------------------
per sec per xact count% of total
--------------------------------------------
Worker Process Requests
Total Requests 0.0 0.0 0 n/a
Worker Process Usage
Total Used 0.0 0.0 0 n/a
Max Ever Used During Sample 0.0 0.0 0 n/a
Memory Requests for Worker Processes
Total Requests 0.0 0.0 0 n/a
Tuning Recommendations for Worker Processes
-------------------------------------------
- Consider decreasing the 'number of worker processes'
configuration parameter.
===============================================================================
Disk I/O Management
-------------------
Max Outstanding I/Os per sec per xact count% of total
---------------------------------------------------------------------
Server n/a n/a 7 n/a
Engine 0 n/a n/a 0 n/a
Engine 1 n/a n/a 7 n/a
Engine 2 n/a n/a 1 n/a
Engine 3 n/a n/a 1 n/a
Engine 4 n/a n/a 1 n/a
Engine 5 n/a n/a 0 n/a
Engine 6 n/a n/a 0 n/a
Engine 7 n/a n/a 0 n/a
Engine 8 n/a n/a 0 n/a
Engine 9 n/a n/a 0 n/a
Engine 10 n/a n/a 0 n/a
Engine 11 n/a n/a 0 n/a
I/Os Delayed by
Disk I/O Structures n/a n/a 0 n/a
Server Config Limit n/a n/a 0 n/a
Engine Config Limit n/a n/a 0 n/a
Operating System Limit n/a n/a 0 n/a
Total Requested Disk I/Os 3.1 3.2 186
Completed Disk I/O's
Engine 0 0.0 0.0 0 0.0 %
Engine 1 0.8 0.8 45 24.2 %
Engine 2 0.3 0.3 17 9.1 %
Engine 3 0.1 0.1 3 1.6 %
Engine 4 2.0 2.1 121 65.1 %
Engine 5 0.0 0.0 0 0.0 %
Engine 6 0.0 0.0 0 0.0 %
Engine 7 0.0 0.0 0 0.0 %
Engine 8 0.0 0.0 0 0.0 %
Engine 9 0.0 0.0 0 0.0 %
Engine 10 0.0 0.0 0 0.0 %
Engine 11 0.0 0.0 0 0.0 %
-----------------------------------------------------------
Total Completed I/Os 3.1 3.2 186
Device Activity Detail
----------------------
Device:
/home/sybase/data/DataDev.dat
DataDev per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 1.1 1.1 63 70.0 %
Writes 0.5 0.5 27 30.0 %
---------------------------------------------------------------------
Total I/Os 1.5 1.6 90 48.4 %
-----------------------------------------------------------------------------
Device:
/home/sybase/data/LogDev.dat
LogDev per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 1.1 1.1 63 100.0 %
---------------------------------------------------------------------
Total I/Os 1.1 1.1 63 33.9 %
-----------------------------------------------------------------------------
Device:
/home/sybase/data/TempDev.dat
TempDev per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.3 0.3 16 51.6 %
Writes 0.3 0.3 15 48.4 %
---------------------------------------------------------------------
Total I/Os 0.5 0.5 31 16.7 %
-----------------------------------------------------------------------------
Device:
/home/sybase/data/master.dat
master per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 0.0 0.0 2 100.0 %
---------------------------------------------------------------------
Total I/Os 0.0 0.0 2 1.1 %
-----------------------------------------------------------------------------
Device:
/home/sybase/data/sybsysdb.dat
systemdbdev per sec per xact count% of total
---------------------------------------------------------------------
Total I/Os 0.0 0.0 0 n/a
---------------------------------------------------------------------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/home/sybase/data/sysprocs.dat
sysprocsdev per sec per xact count% of total
---------------------------------------------------------------------
Total I/Os 0.0 0.0 0 n/a
---------------------------------------------------------------------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
===============================================================================
Network I/O Management
----------------------
Total Network I/O Requests 5.5 5.6 327 n/a
Network I/Os Delayed 0.0 0.0 0 0.0 %
Total TDS Packets Received per sec per xact count% of total
---------------------------------------------------------------------
Engine 0 0.0 0.0 0 0.0 %
Engine 1 0.0 0.0 0 0.0 %
Engine 2 1.6 1.6 95 47.0 %
Engine 3 1.8 1.8 107 53.0 %
Engine 4 0.0 0.0 0 0.0 %
Engine 5 0.0 0.0 0 0.0 %
Engine 6 0.0 0.0 0 0.0 %
Engine 7 0.0 0.0 0 0.0 %
Engine 8 0.0 0.0 0 0.0 %
Engine 9 0.0 0.0 0 0.0 %
Engine 10 0.0 0.0 0 0.0 %
Engine 11 0.0 0.0 0 0.0 %
-----------------------------------------------------------
Total TDS Packets Rec'd 3.4 3.5 202
Total Bytes Received per sec per xact count% of total
---------------------------------------------------------------------
Engine 0 0.0 0.0 0 0.0 %
Engine 1 0.0 0.0 0 0.0 %
Engine 2 438.6 453.7 26313 47.8 %
Engine 3 478.9 495.4 28735 52.2 %
Engine 4 0.0 0.0 0 0.0 %
Engine 5 0.0 0.0 0 0.0 %
Engine 6 0.0 0.0 0 0.0 %
Engine 7 0.0 0.0 0 0.0 %
Engine 8 0.0 0.0 0 0.0 %
Engine 9 0.0 0.0 0 0.0 %
Engine 10 0.0 0.0 0 0.0 %
Engine 11 0.0 0.0 0 0.0 %
-----------------------------------------------------------
Total Bytes Rec'd 917.5 949.1 55048
Avg Bytes Rec'd per Packet n/a n/a 272 n/a
-----------------------------------------------------------------------------
Total TDS Packets Sent per sec per xact count% of total
---------------------------------------------------------------------
Engine 0 0.0 0.0 0 0.0 %
Engine 1 0.0 0.0 0 0.0 %
Engine 2 1.1 1.1 63 48.8 %
Engine 3 1.1 1.1 66 51.2 %
Engine 4 0.0 0.0 0 0.0 %
Engine 5 0.0 0.0 0 0.0 %
Engine 6 0.0 0.0 0 0.0 %
Engine 7 0.0 0.0 0 0.0 %
Engine 8 0.0 0.0 0 0.0 %
Engine 9 0.0 0.0 0 0.0 %
Engine 10 0.0 0.0 0 0.0 %
Engine 11 0.0 0.0 0 0.0 %
-----------------------------------------------------------
Total TDS Packets Sent 2.2 2.2 129
Total Bytes Sent per sec per xact count% of total
---------------------------------------------------------------------
Engine 0 0.0 0.0 0 0.0 %
Engine 1 0.0 0.0 0 0.0 %
Engine 2 243.7 252.1 14623 56.5 %
Engine 3 187.7 194.2 11261 43.5 %
Engine 4 0.0 0.0 0 0.0 %
Engine 5 0.0 0.0 0 0.0 %
Engine 6 0.0 0.0 0 0.0 %
Engine 7 0.0 0.0 0 0.0 %
Engine 8 0.0 0.0 0 0.0 %
Engine 9 0.0 0.0 0 0.0 %
Engine 10 0.0 0.0 0 0.0 %
Engine 11 0.0 0.0 0 0.0 %
-----------------------------------------------------------
Total Bytes Sent 431.4 446.3 25884
Avg Bytes Sent per Packet n/a n/a 200 n/a
=============================== End of Report =================================
(1 row affected)
(return status = 0)
检查data cache情况
页:
[1]