SQL的命中率太低,reload很高:
[php]
GetPctPinPct
Invali-
Namespace RequestsMiss Requests Miss Reloadsdations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY
22,3390.0 22,3390.0
00
CLUSTER
8,5680.1 11,2310.1
00
INDEX
1,8258.5
1,6809.3
00
'SQL AREA
546,506 29.31,751,169 19.6 13,244848'
TABLE/PROCEDURE710,8320.11,289,0640.31,7020
TRIGGER
84,3600.0 84,3600.0
90
-------------------------------------------------------------
[/php]
这个Execute to Parse %的症状相符.
Latch竞争也说明了这个问题:
[php]
Latch Sleep breakdown for DB: NCSIDBInstance: ncsiSnaps: 11 -16
-> ordered by misses desc
Get
Spin &
Latch Name
RequestsMissesSleeps Sleeps 1->4
-------------------------- -------------- ----------- ----------- ------------
shared pool
11,577,28437,843 4,453 33628/4032/1
55/28/0
library cache
12,471,92823,618 3,037 20888/2505/1
85/40/0
.
[/php]
|