
平台论坛博客文库

论坛徽章:: 0

11楼 [报告]

发表于 2006-01-09 12:04 |只看该作者

set showplan on
go
set statistics io,tim on
go
select getdate()
go
your query here
select get date()
go

Please check the 'cpu time','elapsed time', 'physical read' on different machines, I think on the slower one, you have more 'elapsed time', then check your disk io performance

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

2BeSybPro

稍有积蓄

论坛徽章:: 0

12楼 [报告]

发表于 2006-01-09 12:05 |只看该作者

sorry,
set statistics io,time on

gugong

稍有积蓄

论坛徽章:: 0

13楼 [报告]

发表于 2006-01-09 12:39 |只看该作者

-bash-3.00$ isql -SRanan -Usa -P
1> set showplan on
2> go
1> set statistics io,time on
2> go
QUERY PLAN FOR STATEMENT 1 (at line 1).
STEP 1
The type of query is SET STATISTICS ON.
Total writes for this command: 0
Execution Time 0.
SQL Server cpu time: 0 ms. SQL Server elapsed time: 6 ms.
1> select getdate()
2> go
QUERY PLAN FOR STATEMENT 1 (at line 1).
STEP 1
The type of query is SELECT.
Parse and Compile Time 0.
SQL Server cpu time: 0 ms.
--------------------------
Jan 9 2006 12:34PM
Total writes for this command: 0
Execution Time 0.
SQL Server cpu time: 0 ms. SQL Server elapsed time: 0 ms.
(1 row affected)
1> use ESBIS
2> go
QUERY PLAN FOR STATEMENT 1 (at line 1).
STEP 1
The type of query is USE DATABASE.
Parse and Compile Time 0.
SQL Server cpu time: 0 ms.
Total writes for this command: 0
Execution Time 0.
SQL Server cpu time: 0 ms. SQL Server elapsed time: 0 ms.
1> select convert(varchar(20),getdate(),9)
2> SELECT ReceiveID,StockID,ReceiveDate,SumVariety,Priority,(CASE (select count(*) from Prod_Dispense where (Status ='05'OR Status ='06') AND SourceID = r.ReceiveID) WHEN 0 then '04' else '05' END) AS Status,
3> (select max(distinct l.TempAreaID) + '区' from Logi_ReceiveList l where r.ReceiveID = l.ReceiveID) as TempAreaID,
4> ProvName,DeptName,(SELECT Distinct DealMode FROM Prod_Dispense WHERE SourceID = r.ReceiveID) AS DealMode
5> FROM Logi_Receive r LEFT OUTER JOIN Bas_Prov ON Bas_Prov.ProvID = r.ProviderID LEFT OUTER JOIN Bas_DeptInfo ON Bas_DeptInfo.DeptID = r.FillDeptID
6> WHERE ReceiveID IN (SELECT Distinct SourceID FROM Prod_Dispense WHERE Status IN ('04','05'))
7> ORDER BY DealMode ASC,Priority desc, AuditDate ASC
8> select convert(varchar(20),getdate(),9)
9> go
...
Table: Prod_Dispense scan count 1, logical reads: (regular=5717 apf=0
total=5717), physical reads: (regular=5714 apf=0 total=5714), apf IOs used=0
Table: Logi_ReceiveList scan count 202, logical reads: (regular=2998 apf=0
total=2998), physical reads: (regular=676 apf=0 total=676), apf IOs used=0
Table: Prod_Dispense scan count 1, logical reads: (regular=5717 apf=0
total=5717), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Logi_Receive scan count 1, logical reads: (regular=1651 apf=0
total=1651), physical reads: (regular=1603 apf=0 total=1603), apf IOs used=0
Table: Bas_Prov scan count 9736, logical reads: (regular=29683 apf=0
total=29683), physical reads: (regular=100 apf=0 total=100), apf IOs used=0
Table: Bas_DeptInfo scan count 9736, logical reads: (regular=9740 apf=0
total=9740), physical reads: (regular=3 apf=0 total=3), apf IOs used=0
Table: Prod_Dispense scan count 1, logical reads: (regular=5717 apf=0
total=5717), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Worktable1 scan count 202, logical reads: (regular=63186 apf=0
total=63186), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Worktable2 scan count 202, logical reads: (regular=65238 apf=0
total=65238), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Worktable3 scan count 0, logical reads: (regular=240 apf=0 total=240),
physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Worktable4 scan count 9736, logical reads: (regular=21174 apf=0
total=21174), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Total writes for this command: 4216
Execution Time 8.
SQL Server cpu time: 800 ms. SQL Server elapsed time: 35676 ms.
(202 rows affected)
--------------------
Jan 9 2006 12:38:52
Total writes for this command: 0
Execution Time 0.
SQL Server cpu time: 0 ms. SQL Server elapsed time: 0 ms.
(1 row affected)
1>

复制代码

gugong

稍有积蓄

论坛徽章:: 0

14楼 [报告]

发表于 2006-01-09 12:42 |只看该作者

第二次

1> select convert(varchar(20),getdate(),9)
2> SELECT ReceiveID,StockID,ReceiveDate,SumVariety,Priority,(CASE (select count(*) from Prod_Dispense where (Status ='05'OR Status ='06') AND SourceID = r.ReceiveID) WHEN 0 then '04' else '05' END) AS Status,
3> (select max(distinct l.TempAreaID) + '区' from Logi_ReceiveList l where r.ReceiveID = l.ReceiveID) as TempAreaID,
4> ProvName,DeptName,(SELECT Distinct DealMode FROM Prod_Dispense WHERE SourceID = r.ReceiveID) AS DealMode
5> FROM Logi_Receive r LEFT OUTER JOIN Bas_Prov ON Bas_Prov.ProvID = r.ProviderID LEFT OUTER JOIN Bas_DeptInfo ON Bas_DeptInfo.DeptID = r.FillDeptID
6> WHERE ReceiveID IN (SELECT Distinct SourceID FROM Prod_Dispense WHERE Status IN ('04','05'))
7> ORDER BY DealMode ASC,Priority desc, AuditDate ASC
8> select convert(varchar(20),getdate(),9)
9> go
...
Table: Prod_Dispense scan count 1, logical reads: (regular=5717 apf=0
total=5717), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Logi_ReceiveList scan count 202, logical reads: (regular=2998 apf=0
total=2998), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Prod_Dispense scan count 1, logical reads: (regular=5717 apf=0
total=5717), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Logi_Receive scan count 1, logical reads: (regular=1651 apf=0
total=1651), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Bas_Prov scan count 9736, logical reads: (regular=29683 apf=0
total=29683), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Bas_DeptInfo scan count 9736, logical reads: (regular=9740 apf=0
total=9740), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Prod_Dispense scan count 1, logical reads: (regular=5717 apf=0
total=5717), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Worktable1 scan count 202, logical reads: (regular=63186 apf=0
total=63186), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Worktable2 scan count 202, logical reads: (regular=65238 apf=0
total=65238), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Worktable3 scan count 0, logical reads: (regular=240 apf=0 total=240),
physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Worktable4 scan count 9736, logical reads: (regular=21174 apf=0
total=21174), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Total writes for this command: 4741
Execution Time 9.
SQL Server cpu time: 900 ms. SQL Server elapsed time: 4323 ms.
(202 rows affected)
--------------------
Jan 9 2006 12:41:35
Total writes for this command: 0
Execution Time 0.
SQL Server cpu time: 0 ms. SQL Server elapsed time: 0 ms.
(1 row affected)

复制代码

gugong

稍有积蓄

论坛徽章:: 0

15楼 [报告]

发表于 2006-01-09 12:43 |只看该作者

中间 ... 省略的是：

9> go
QUERY PLAN FOR STATEMENT 1 (at line 1).
STEP 1
The type of query is SELECT.
QUERY PLAN FOR STATEMENT 2 (at line 2).
STEP 1
The type of query is INSERT.
The update mode is direct.
Worktable1 created for REFORMATTING.
FROM TABLE
Prod_Dispense
Nested iteration.
Table Scan.
Forward scan.
Positioning at start of table.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
TO TABLE
Worktable1.
STEP 2
The type of query is INSERT.
The update mode is direct.
Worktable2 created for REFORMATTING.
FROM TABLE
Prod_Dispense
Nested iteration.
Table Scan.
Forward scan.
Positioning at start of table.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
TO TABLE
Worktable2.
STEP 3
The type of query is INSERT.
The update mode is direct.
Worktable4 created for REFORMATTING.
FROM TABLE
Prod_Dispense
Nested iteration.
Table Scan.
Forward scan.
Positioning at start of table.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
TO TABLE
Worktable4.
STEP 4
The type of query is INSERT.
The update mode is direct.
Worktable3 created, in allpages locking mode, for ORDER BY.
FROM TABLE
Logi_Receive
r
Nested iteration.
Table Scan.
Forward scan.
Positioning at start of table.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
FROM TABLE
Bas_Prov
Nested iteration.
Index : Bas_Prov_x
Forward scan.
Positioning by key.
Keys are:
ProvID ASC
Using I/O Size 2 Kbytes for index leaf pages.
With LRU Buffer Replacement Strategy for index leaf pages.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
FROM TABLE
Bas_DeptInfo
Nested iteration.
Index : PK_BAS_DEPTINFO
Forward scan.
Positioning by key.
Keys are:
DeptID ASC
Using I/O Size 2 Kbytes for index leaf pages.
With LRU Buffer Replacement Strategy for index leaf pages.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
FROM TABLE
Worktable4.
EXISTS TABLE : nested iteration.
Using Clustered Index.
Forward scan.
Positioning by key.
Run subquery 1 (at nesting level 1).
Run subquery 2 (at nesting level 1).
Run subquery 3 (at nesting level 1).
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
TO TABLE
Worktable3.
STEP 5
The type of query is SELECT.
This step involves sorting.
FROM TABLE
Worktable3.
Using GETSORTED
Table Scan.
Forward scan.
Positioning at start of table.
Using I/O Size 2 Kbytes for data pages.
With MRU Buffer Replacement Strategy for data pages.
STEP 1
NESTING LEVEL 1 SUBQUERIES FOR STATEMENT 2.
QUERY PLAN FOR SUBQUERY 1 (at nesting level 1 and at line 2).
Correlated Subquery.
Subquery under an EXPRESSION predicate.
STEP 1
The type of query is SELECT.
Evaluate Ungrouped COUNT AGGREGATE.
FROM TABLE
Worktable1.
Nested iteration.
Using Clustered Index.
Forward scan.
Positioning by key.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
END OF QUERY PLAN FOR SUBQUERY 1.
QUERY PLAN FOR SUBQUERY 2 (at nesting level 1 and at line 3).
Correlated Subquery.
Subquery under an EXPRESSION predicate.
STEP 1
The type of query is SELECT.
Evaluate Ungrouped MAXIMUM AGGREGATE.
FROM TABLE
Logi_ReceiveList
l
Nested iteration.
Index : PK_LOGI_RECEIVEILIST
Forward scan.
Positioning by key.
Keys are:
ReceiveID ASC
Using I/O Size 2 Kbytes for index leaf pages.
With LRU Buffer Replacement Strategy for index leaf pages.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
STEP 2
The type of query is SELECT.
Evaluate Ungrouped ONCE AGGREGATE.
END OF QUERY PLAN FOR SUBQUERY 2.
QUERY PLAN FOR SUBQUERY 3 (at nesting level 1 and at line 4).
Correlated Subquery.
Subquery under an EXPRESSION predicate.
STEP 1
The type of query is SELECT.
Evaluate Ungrouped ONCE-UNIQUE AGGREGATE.
FROM TABLE
Worktable2.
Nested iteration.
Using Clustered Index.
Forward scan.
Positioning by key.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
END OF QUERY PLAN FOR SUBQUERY 3.
QUERY PLAN FOR STATEMENT 3 (at line 8).
STEP 1
The type of query is SELECT.
Parse and Compile Time 0.
SQL Server cpu time: 0 ms.
--------------------
Jan 9 2006 12:41:31
Total writes for this command: 0
Execution Time 0.
SQL Server cpu time: 0 ms. SQL Server elapsed time: 0 ms.
(1 row affected)
The sort for Worktable1 is done in Serial
The sort for Worktable2 is done in Serial
The sort for Worktable4 is done in Serial
The sort for Worktable3 is done in Serial
ReceiveID StockID ReceiveDate SumVariety
Priority Status TempAreaID
ProvName
DeptName
DealMode
------------------ ------------------ -------------------------- -----------
----------- ------ ------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------

复制代码

zhhui2000

家境小康

论坛徽章:: 0

16楼 [报告]

发表于 2006-01-09 13:01 |只看该作者

我感觉是临时库的问题？
临时库的配置如何，用的什么设备？试试把临时库建在内存里。

方便的法，把两个环境的配置及做这个大动作时的sysmon结果贴来看看/

[ 本帖最后由 zhhui2000 于 2006-1-9 13:09 编辑 ]

gugong

稍有积蓄

论坛徽章:: 0

17楼 [报告]

发表于 2006-01-09 13:10 |只看该作者

上面是 4 CPU 、16 G 内存、SCSI 机器的。

时间在 4-5 秒之间。

下面是 2CPU、8G 内存、SATAII 机器的：

时间在 1-2 秒之间。

9> select getdate()
10> go
QUERY PLAN FOR STATEMENT 1 (at line 1).
STEP 1
The type of query is SELECT.
QUERY PLAN FOR STATEMENT 2 (at line 2).
STEP 1
The type of query is INSERT.
The update mode is direct.
Worktable1 created for REFORMATTING.
FROM TABLE
Prod_Dispense
Nested iteration.
Table Scan.
Forward scan.
Positioning at start of table.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
TO TABLE
Worktable1.
STEP 2
The type of query is INSERT.
The update mode is direct.
Worktable2 created for REFORMATTING.
FROM TABLE
Prod_Dispense
Nested iteration.
Table Scan.
Forward scan.
Positioning at start of table.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
TO TABLE
Worktable2.
STEP 3
The type of query is INSERT.
The update mode is direct.
Worktable4 created for REFORMATTING.
FROM TABLE
Prod_Dispense
Nested iteration.
Table Scan.
Forward scan.
Positioning at start of table.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
TO TABLE
Worktable4.
STEP 4
The type of query is INSERT.
The update mode is direct.
Worktable3 created, in allpages locking mode, for ORDER BY.
FROM TABLE
Logi_Receive
r
Nested iteration.
Table Scan.
Forward scan.
Positioning at start of table.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
FROM TABLE
Bas_Prov
Nested iteration.
Index : Bas_Prov_x
Forward scan.
Positioning by key.
Keys are:
ProvID ASC
Using I/O Size 2 Kbytes for index leaf pages.
With LRU Buffer Replacement Strategy for index leaf pages.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
FROM TABLE
Bas_DeptInfo
Nested iteration.
Index : PK_BAS_DEPTINFO
Forward scan.
Positioning by key.
Keys are:
DeptID ASC
Using I/O Size 2 Kbytes for index leaf pages.
With LRU Buffer Replacement Strategy for index leaf pages.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
FROM TABLE
Worktable4.
EXISTS TABLE : nested iteration.
Using Clustered Index.
Forward scan.
Positioning by key.
Run subquery 1 (at nesting level 1).
Run subquery 2 (at nesting level 1).
Run subquery 3 (at nesting level 1).
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
TO TABLE
Worktable3.
STEP 5
The type of query is SELECT.
This step involves sorting.
FROM TABLE
Worktable3.
Using GETSORTED
Table Scan.
Forward scan.
Positioning at start of table.
Using I/O Size 2 Kbytes for data pages.
With MRU Buffer Replacement Strategy for data pages.
STEP 1
NESTING LEVEL 1 SUBQUERIES FOR STATEMENT 2.
QUERY PLAN FOR SUBQUERY 1 (at nesting level 1 and at line 2).
Correlated Subquery.
Subquery under an EXPRESSION predicate.
STEP 1
The type of query is SELECT.
Evaluate Ungrouped COUNT AGGREGATE.
FROM TABLE
Worktable1.
Nested iteration.
Using Clustered Index.
Forward scan.
Positioning by key.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
END OF QUERY PLAN FOR SUBQUERY 1.
QUERY PLAN FOR SUBQUERY 2 (at nesting level 1 and at line 3).
Correlated Subquery.
Subquery under an EXPRESSION predicate.
STEP 1
The type of query is SELECT.
Evaluate Ungrouped MAXIMUM AGGREGATE.
FROM TABLE
Logi_ReceiveList
l
Nested iteration.
Index : PK_LOGI_RECEIVEILIST
Forward scan.
Positioning by key.
Keys are:
ReceiveID ASC
Using I/O Size 2 Kbytes for index leaf pages.
With LRU Buffer Replacement Strategy for index leaf pages.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
STEP 2
The type of query is SELECT.
Evaluate Ungrouped ONCE AGGREGATE.
END OF QUERY PLAN FOR SUBQUERY 2.
QUERY PLAN FOR SUBQUERY 3 (at nesting level 1 and at line 4).
Correlated Subquery.
Subquery under an EXPRESSION predicate.
STEP 1
The type of query is SELECT.
Evaluate Ungrouped ONCE-UNIQUE AGGREGATE.
FROM TABLE
Worktable2.
Nested iteration.
Using Clustered Index.
Forward scan.
Positioning by key.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
END OF QUERY PLAN FOR SUBQUERY 3.
QUERY PLAN FOR STATEMENT 3 (at line 8).
STEP 1
The type of query is SELECT.
QUERY PLAN FOR STATEMENT 4 (at line 9).
STEP 1
The type of query is SELECT.
Parse and Compile Time 0.
SQL Server cpu time: 0 ms.
--------------------
Jan 9 2006 1:07:46
Total writes for this command: 0
Execution Time 0.
SQL Server cpu time: 0 ms. SQL Server elapsed time: 0 ms.
(1 row affected)
The sort for Worktable1 is done in Serial
The sort for Worktable2 is done in Serial
The sort for Worktable4 is done in Serial
The sort for Worktable3 is done in Serial
ReceiveID StockID ReceiveDate SumVariety
Priority Status TempAreaID
ProvName
DeptName
DealMode
------------------ ------------------ -------------------------- -----------
----------- ------ ------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------
.......................
03
Table: Prod_Dispense scan count 1, logical reads: (regular=5717 apf=0
total=5717), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Logi_ReceiveList scan count 202, logical reads: (regular=2998 apf=0
total=2998), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Prod_Dispense scan count 1, logical reads: (regular=5717 apf=0
total=5717), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Logi_Receive scan count 1, logical reads: (regular=1651 apf=0
total=1651), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Bas_Prov scan count 9736, logical reads: (regular=29683 apf=0
total=29683), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Bas_DeptInfo scan count 9736, logical reads: (regular=9740 apf=0
total=9740), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Prod_Dispense scan count 1, logical reads: (regular=5717 apf=0
total=5717), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Worktable1 scan count 202, logical reads: (regular=63186 apf=0
total=63186), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Worktable2 scan count 202, logical reads: (regular=65238 apf=0
total=65238), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Worktable3 scan count 0, logical reads: (regular=240 apf=0 total=240),
physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Worktable4 scan count 9736, logical reads: (regular=21174 apf=0
total=21174), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Total writes for this command: 4741
Execution Time 9.
SQL Server cpu time: 900 ms. SQL Server elapsed time: 1183 ms.
(202 rows affected)
--------------------
Jan 9 2006 1:07:47
Total writes for this command: 0
Execution Time 0.
SQL Server cpu time: 0 ms. SQL Server elapsed time: 0 ms.
(1 row affected)
--------------------------
Jan 9 2006 1:07PM
Total writes for this command: 0
Execution Time 0.
SQL Server cpu time: 0 ms. SQL Server elapsed time: 0 ms.
(1 row affected)

复制代码

时间是 1183 ms

1017of

大富大贵

论坛徽章:: 4

18楼 [报告]

发表于 2006-01-09 13:11 |只看该作者

wow,how complex the sql is.as you decribed above,first execution,some large table did more physical I/Os than second time.SQL Server elapsed time in second time fell into 4323 ms probably because less physical happened.I am not clear what you try to say.
btw:don't give such complex sql to ASE, sometime it will fail to get it work efficiently.

gugong

稍有积蓄

论坛徽章:: 0

19楼 [报告]

发表于 2006-01-09 14:45 |只看该作者

你说的对。

我现在所疑问的是，在 scci 硬盘和 sata II 硬盘所表现出来的差异是如此的大。

2BeSybPro

稍有积蓄

论坛徽章:: 0

20楼 [报告]

发表于 2006-01-10 09:19 |只看该作者

The elapsed time is much bigger on one machine than another, indicating that Adaptive Server spent
some time processing other tasks or waiting for disk or network I/O to complete. Please check the disks are configured properly, such as dsync or preferred plex (if you are using VCS).

123 / 3 页下一页

返回列表

Chinaunix › 论坛 › 数据库技术 › Sybase › Sybase 调优问题（内存与磁盘 I/O）

Sybase 调优问题（内存与磁盘 I/O） [复制链接]