Alphabetical list of configuration parameters (used by sp_configure) that control, affect, use, or report ASE memory / ASE cache configuration.
- additional network memory - specifies the maximum size of additional memory that can be used for network packets that are larger than the default packet size.
- allow resource limits - specifies the use of resource limits.
- audit queue size - specifies the size of the audit records / audit queue.
- default network packet size - specifies the default packet size for all ASE Server users.
- event buffers per engine - specifies the number of events per ASE Server engine that can be monitored simultaneously by ASE Monitor.
- max number network listeners - specifies the maximum number of network listeners allowed by an ASE Server at one time.
- max online engines - specifies the maximum number of ASE Server engines that can be online at any one time in an SMP environment.
- max SQL text monitored - specifies the total number of bytes an ASE Server allocates for each user task to store SQL text.
- memory per worker processes - specifies the amount of memory (in bytes) used by worker processes. Each worker process requires memory for messaging during query processing. This memory is allocated from a shared memory pool.
- number of alarms - specifies the number of alarm structures allocated by an ASE Server.
- number of aux scan descriptors - specifies the number of auxiliary scan descriptors available in a pool shared by all users on an ASE server.
- number of devices - specifies the number of database devices an ASE Server can use.
- number of large i/o buffers - specifies the number of allocation unit-sized buffers reserved for performing large I/O for certain ASE Server utilities.
- number of mailboxes - specifies the number of mailbox structures allocated by an ASE Server.
- number of messages - specifies the number of message structures allocated by an ASE Server.
- number of open databases - specifies the maximum number of databases that can be open simultaneously on an ASE Server.
- number of open indexes - specifies the maximum number of indexes that can be used simultaneously on ASE Server.
- number of open objects - specifies the maximum number of objects that can be open simultaneously on an ASE Server.
- number of open partitions - specifies the number of partitions that an ASE Server can access at one time.
- number of remote connections - specifies the number of logical connections that can be open to and from an ASE Server at one time.
- number of remote logins - controls the number of active user connections from ASE Server to remote servers.
- number of remote sites - determines the maximum number of remote sites that can access a ASE server simultaneously.
- number or worker processes - specify the maximum number of worker processes that ASE servers can use for all simultaneously running parallel queries.
- permission cache entries - determines the number of cache protectors per task.
- procedure cache size - specifies the size of your procedure cache in 2K pages, regardless of the server's logical page size.
- remote server pre-read packets - etermines the number of packets that will be "pre-read" by a site handler during connections with remote servers.
- stack guard size - specifies the size (in bytes) of the stack guard area. The stack guard area is an overflow stack of configurable size at the end of each stack.
- stack size - specifies the size (in bytes) of the execution stacks used by each user process on an ASE Server.
- total logical memory - reports the actual memory requirement for ASE. Excluding any memory required for the executable.
- user log cache size - specifies the size (in bytes) for each user's log cache.
To report/display the ASE cache configuration use sp_helpcache
To configure the ASE cache use sp_cacheconfig