- 论坛徽章:
- 0
|
回复 #8 flybean 的帖子
telalm_cache是我昨天白天加的,默认cache我也调高了,下午系统提升明显,晚上9点共单库(awsdyndbg)出现阻塞,不知道怎么会回滚的,进程ID1411不能kill,最后重启了server。但是不知道问题发生了原因,问题出现之前,有个客户对数据库进行了4000行记录的update操作
SELECT 0
0 1411 sleeping telstar telstar sxcncwg2 0 awsdyndb
ROLLBACK 0
0 1434 lock sleep telstar telstar sxcncwg2 1411 awsdyndb
SELECT 0
0 1499 recv sleep telstar telstar sxcncwg2 0 staticdb
AWAITING COMMAND 0
0 1517 lock sleep telstar telstar sxcncwg2 1411 awsdyndb
SELECT 0
cache配置
sp_cacheconfig
2> go
Cache Name Status Type Config Value Run Value
------------------------------ --------- -------- ------------ ------------
awsdyndb_ews_cache Active Mixed 256.00 Mb 256.00 Mb
awsdyndb_ews_task_cache Active Mixed 1024.00 Mb 1024.00 Mb
default data cache Active Default 2048.00 Mb 2048.00 Mb
telalm_cache Active Mixed 2048.00 Mb 2048.00 Mb
tempdb_cache Active Mixed 2048.00 Mb 2048.00 Mb
worktradb_cache Active Mixed 1024.00 Mb 1024.00 Mb
------------ ------------
Total 8448.00 Mb 8448.00 Mb
==========================================================================
Cache: awsdyndb_ews_cache, Status: Active, Type: Mixed
Config Size: 256.00 Mb, Run Size: 256.00 Mb
Config Replacement: relaxed LRU, Run Replacement: relaxed LRU
Config Partition: 8, Run Partition: 8
IO Size Wash Size Config Size Run Size APF Percent
-------- --------- ------------ ------------ -----------
8 Kb 26176 Kb 0.00 Mb 128.00 Mb 10
16 Kb 26112 Kb 128.00 Mb 128.00 Mb 10
==========================================================================
Cache: awsdyndb_ews_task_cache, Status: Active, Type: Mixed
Config Size: 1024.00 Mb, Run Size: 1024.00 Mb
Config Replacement: relaxed LRU, Run Replacement: relaxed LRU
Config Partition: 16, Run Partition: 16
IO Size Wash Size Config Size Run Size APF Percent
-------- --------- ------------ ------------ -----------
8 Kb 157184 Kb 0.00 Mb 768.00 Mb 10
16 Kb 52224 Kb 256.00 Mb 256.00 Mb 10
==========================================================================
Cache: default data cache, Status: Active, Type: Default
Config Size: 2048.00 Mb, Run Size: 2048.00 Mb
Config Replacement: relaxed LRU, Run Replacement: relaxed LRU
Config Partition: 1, Run Partition: 4
IO Size Wash Size Config Size Run Size APF Percent
-------- --------- ------------ ------------ -----------
8 Kb 245760 Kb 0.00 Mb 2016.00 Mb 10
16 Kb 6528 Kb 32.00 Mb 32.00 Mb 10
==========================================================================
Cache: telalm_cache, Status: Active, Type: Mixed
Config Size: 2048.00 Mb, Run Size: 2048.00 Mb
Config Replacement: relaxed LRU, Run Replacement: strict LRU
Config Partition: 1, Run Partition: 1
IO Size Wash Size Config Size Run Size APF Percent
-------- --------- ------------ ------------ -----------
8 Kb 61440 Kb 0.00 Mb 1024.00 Mb 10
16 Kb 61440 Kb 1024.00 Mb 1024.00 Mb 10
==========================================================================
Cache: tempdb_cache, Status: Active, Type: Mixed
Config Size: 2048.00 Mb, Run Size: 2048.00 Mb
Config Replacement: relaxed LRU, Run Replacement: relaxed LRU
Config Partition: 4, Run Partition: 4
IO Size Wash Size Config Size Run Size APF Percent
-------- --------- ------------ ------------ -----------
8 Kb 209696 Kb 0.00 Mb 1024.00 Mb 10
16 Kb 209664 Kb 1024.00 Mb 1024.00 Mb 10
==========================================================================
Cache: worktradb_cache, Status: Active, Type: Mixed
Config Size: 1024.00 Mb, Run Size: 1024.00 Mb
Config Replacement: strict LRU, Run Replacement: strict LRU
Config Partition: 4, Run Partition: 4
IO Size Wash Size Config Size Run Size APF Percent
-------- --------- ------------ ------------ -----------
8 Kb 183488 Kb 0.00 Mb 896.00 Mb 10
16 Kb 26176 Kb 128.00 Mb 128.00 Mb 10
(return status = 0) |
|