avatar image
Former Member

sp_cacheconfig and sp_poolconfig -- not gining correct value (Config Vrs Ryn value)

1) We have created 6000 MB for user defined named cache " tempdb_cache" .

2) created 16 KB buffer pool with 3000 MB .

Issue : 2 KB buffer pool showing ( Config values 1000MB and run values 3000 MB)

as per my understanding both should be 3000MB .

see the attached output of : sp_cacheconfig tempdb_cache

sp-cacheconfig.txt

Version : Adaptive Server Enterprise/16.0 SP02 PL02/EBF 25318 SMP/P/RS6000/AIX 7.1/ase160sp02plx/2492/64-bit/FBO/Sun Nov 22 18:44:08 2015

Cache Name Status Type Config Value Run Value ------------ -------- -------- -------------- ------------ tempdb_cache Active Mixed 6000.00 Mb 6000.00 Mb ------------ ------------ Total 6000.00 Mb 6000.00 Mb ========================================================================== Cache: tempdb_cache, Status: Active, Type: Mixed Config Size: 6000.00 Mb, Run Size: 6000.00 Mb Config Replacement: strict LRU, Run Replacement: strict LRU Config Partition: 8, Run Partition: 8 IO Size Wash Size Config Size Run Size APF Percent -------- ------------- ------------ ------------ ----------- 2 Kb 409600 Kb 1000.00 Mb 3000.00 Mb 15 16 Kb 102400 Kb 3000.00 Mb 3000.00 Mb 15

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers

Skip to Content