對指定數(shù)據(jù)庫添加設(shè)備奇慢無比

飛眉

這兩天準(zhǔn)備做壓力測試，但往數(shù)據(jù)庫里面寫數(shù)據(jù)或添加設(shè)備的時候非常慢。請問往數(shù)據(jù)庫里面添加設(shè)備時候具體操作是怎么樣，哪位兄弟有相關(guān)文檔？

以下是在添加一個10G的設(shè)備時候做的監(jiān)控，調(diào)整IO 需要注意那些參數(shù)或有那些注意的地方？

是sp_sysmon "00:10:00",diskio 的結(jié)果

00:00000:00018:2005/12/28 20:58:19.68 server DBCC TRACEON 8399, SPID 18
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
===============================================================================
Sybase Adaptive Server Enterprise System Performance Report
===============================================================================

Server Version: Adaptive Server Enterprise/12.5/SWR 9609 GA/P/Sun_svr4/O
Server Name: TIPS
Run Date: Dec 28, 2005
Statistics Cleared at: 20:48:19
Statistics Sampled at: 20:58:19
Sample Interval: 00:10:00

===============================================================================
===============================================================================

Disk I/O Management
-------------------

Max Outstanding I/Os per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Server n/a n/a 2 n/a
Engine 0 n/a n/a 0 n/a
Engine 1 n/a n/a 1 n/a
Engine 2 n/a n/a 0 n/a
Engine 3 n/a n/a 2 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 0.0 0.5 10

Completed Disk I/O's
Engine 0 0.0 0.0 0 0.0 %
Engine 1 0.0 0.4 9 0.1 %
Engine 2 0.0 0.0 0 0.0 %
Engine 3 28.2 847.4 16948 99.9 %
------------------------- ------------ ------------ ----------
Total Completed I/Os 28.3 847.8 16957


Device Activity Detail
----------------------

Device:
/disk2/syb_data/tips7.dbf
tips7 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 28.2 847.3 16947 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 28.2 847.3 16947 99.9 %

Device Semaphore Granted 28.2 847.3 16947 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/disk4/syb_data/tips8.dbf
tips8 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:
/disk4/syb_data/tips9.dbf
tips9 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:
/disk5/syb_data/data/master
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.3 5 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.3 5 0.0 %

Device Semaphore Granted 0.0 0.3 5 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/disk5/syb_data/data/sybsystemporcs
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 %


-----------------------------------------------------------------------------

Device:
/disk5/syb_data/data/tips.dbf
tips 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:
/disk5/syb_data/data/tips1.dbf
tips1 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:
/disk5/syb_data/data/tips11.dbf
tips11 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:
/disk5/syb_data/data/tips2.dbf
tips2 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:
/disk5/syb_data/data/tips3.dbf
tips3 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:
/disk5/syb_data/data/tips4.dbf
tips4 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:
/disk5/syb_data/data/tips5.dbf
tips5 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:
/disk5/syb_data/data/tips6.dbf
tips6 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:
/disk5/syb_data/data/tips_log.dbf
tips_log 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:
/disk5/syb_data/tips10.dbf
tips10 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:
/export/home/sybase/syb_data/syb_tempdb.dbf
syb_tempdb 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.3 5 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.3 5 0.0 %

Device Semaphore Granted 0.0 0.3 5 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------