- 论坛徽章:
- 0
|
关于空间分配属性是指specify write option么?
我分别目前我设置的是direct IO,之前使用过Cache io,没什么好的变化。
这是sp_cacheconfig 给出的信息
default data cache Active Default 1024.00 Mb 1024.00 Mb
tempdb_cache Active Mixed 500.00 Mb 500.00 Mb
------------ ------------
Total 1524.00 Mb 1524.00 Mb
==========================================================================
Cache: default data cache, Status: Active, Type: Default
Config Size: 1024.00 Mb, Run Size: 1024.00 Mb
Config Replacement: strict LRU, Run Replacement: strict LRU
Config Partition: 2, Run Partition: 2
IO Size Wash Size Config Size Run Size APF Percent
16 Kb 122880 Kb 959.00 Mb 959.00 Mb 10
32 Kb 13312 Kb 65.00 Mb 65.00 Mb 10
==========================================================================
Cache: tempdb_cache, Status: Active, Type: Mixed
Config Size: 500.00 Mb, Run Size: 500.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
16 Kb 102400 Kb 0.00 Mb 500.00 Mb 10 |
|