Appendix A: Sample ASE Configuration Settings

Cache memory configuration example

In this configuration example, 4GB of memory has been allocated for ASE.

Make the configuration changes for items other than cache that use memory.
Make all configuration changes except the changes for c_log and the default data cache.
Shutdown and restart the server.
Run sp_configure memory

The output is similar to this:

Parameter Name	Default	Memory Used	Config Value	Run Value	Unit	Type
additional network memory	0	0	0	0	bytes	dynamic
allocate max shared memory	0	0	0	0	switch	dynamic
heap memory per user	4096	0	4096	4096	bytes	dynamic
locked shared memory	0	0	1	1	switch	static
max memory	53248	4000000	2000000	2000000	memory pages(2k)	dynamic
memory alignment boundary	4096	0	4096	4096	bytes	static
memory per worker process	1024	4	1024	1024	bytes	dynamic
messaging memory	400	0	400	400	memory pages(2k)	dynamic
shared memory starting address	0	0	0	0	not applicable	static
total logical memory	53248	174190	87095	87092	memory pages(2k)	read-only
total physical memory	0	174192	0	87096	memory pages(2k)	read-only

sp_configure memory returns the information “An additional 3825816 K bytes of memory is available for reconfiguration. This is the difference between 'max memory' and 'total logical memory'.”

3825816K bytes of memory are available and some of this will be used for memory for cache. The rest of the memory is reserved for future changes. The objective is to hold as much data as possible in memory. 800M is allocated for the log and 1700M for the data cache.

Make the configuration changes for c_log and the default data cache.
Shutdown and restart the server.
Run sp_configure memory

The output is similar to this:

Parameter Name	Default	Memory Used	Config Value	Run Value	Unit	Type
additional network memory	0	0	0	0	bytes	dynamic
allocate max shared memory	0	0	0	0	switch	dynamic
heap memory per user	4096	0	4096	4096	bytes	dynamic
lock shared memory	0	0	1	1	switch	static
max memory	53248	4000000	2000000	2000000	memory pages(2k)	dynamic
memory alignment boundary	4096	0	4096	4096	bytes	static
memory per worker process	1024	4	1024	1024	bytes	dynamic
messaging memory	400	0	400	400	memory pages(2k)	dynamic
shared memory starting address	0	0	0	0	not applicable	static
total logical memory	53248	2873302	1436651	1436649	memory pages(2k)	read-only
total physical memory	0	2873304	0	1436652	memory pages(2k)	read-only

sp_configure memory returns the information“An additional 1126702 K bytes of memory is available for reconfiguration. This is the difference between 'max memory' and 'total logical memory'.” To determine how much memory to allocate to data cache for your application, run the following stored procedure commands:

sp_estspace STOCK_TRADE, <nbr of rows>

sp_estspace STOCK_QUOTE, <nbr of rows>

View this book as PDF