Chinaunix

标题: 对指定数据库添加设备奇慢无比 [打印本页]
作者: 飞眉    时间: 2005-12-28 21:38
标题: 对指定数据库添加设备奇慢无比
这两天准备做压力测试，但往数据库里面写数据或添加设备的时候非常慢。请问往数据库里面添加设备时候具体操作是怎么样，哪位兄弟有相关文档？

以下是在添加一个10G的设备时候做的监控，调整IO 需要注意那些参数或有那些注意的地方？

是sp_sysmon "00:10:00",diskio 的结果

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 %

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



欢迎光临 Chinaunix (http://bbs.chinaunix.net/) Powered by Discuz! X3.2