Data cache configuration can not exceed 500M? Physical Memory 4G, ASE allocation of jams, but the default configuration should not exceed the maximum data cache discovered 500M? Procedure 'sp_cacheconfig' Line 1105 : The total size of all configured caches (1887436K) is greater than the memory available for caches (512712K). Will not hesitate to enlighten. Thank you. Max memory first set, and then set up default data cache, using sp_configure "memory" can see how much memory is left to be allocated. Your max memory allocation is? Thank you upstairs can return. Versions will have relationship with ASE. ASE version 12.0. Total installed 1.8G memeory. 12.0 total memory is used to max memory.11.9.2 is installed. Msg 17411, Level 16, State 1 : Procedure 'sp_configure', Line 164 : Configuration option is not unique. Name Default Memory Configuration Parameter Value Used Run Value ------------------------------ ----------- ----------- ------------          ----------- Additional network memory 0 0 0 0 Lock shared memory 0 0 0 0 Memory alignment boundary 2048 0 2048 2048 Memory per worker process 1024 0 1024 1024 Shared memory starting address 0 0 23662592 23662592 Total memory 21504 1835008 917504 917504 Adaptive Server Enterprise/12.0.0.8/P/EBF 11,880 ESD2/NT (IX86) /OS 4.0/2060/32bit /OPT/Thu May 20 23:17:33 2004 Confidential property of Sybase, Inc.. Copyright 1987, 2004 Sybase, Inc.. All rights reserved. Unpublished rights reserved under U.S. copyright laws. No. version. Name Default Memory Configuration Parameter Value Used Run Value ------------------------------ ----------- ----------- ------------          ----------- Abstract plan cache 0 0 0 0 Global cache partition number 1 0 1 1 Number of languages in cache 3 4 3 3 Permission cache entries #279 15 15 15 Procedure cache BNHI 20 1195170 70 70 Unilib cache size of 0 166 0 0 Total data cache size 0 512210 0 512210 User log cache size 2048 0 2048 2048 User log cache spinlock ratio 20 0 20 20 Cache Configuration Sorry, my mistake. You set up a cache of 70%, with the 1.2G, you need to process large cache?, 20% of the general process cache can be located, and what is left to the entire data cache. Thank you, kind of big brother upstairs, I re-established some try. I have also increase your QQ, please certification. [ Closed window ]