z
Memory-Related Variables
All of the following variables use memory. Run sp_configure and look at the
memory used section to see how much memory they are taking up.
sp_configure 'Memory Use'
Chapter 11: Memory Configuration and Tuning
267
additional network memory
audit queue size
cpu grace time
deadlock text pipe max messages
default database size
default fill factor percent
disk i/o structures
errorlog text pipe max messages
max cis remote connections
memory per worker process
number of alarms
number of aux scan descriptors
number of devices
number of dtx participants
number of java sockets
number of large i/o buffers
number of locks
number of mailboxes
number of messages
number of open databases
number of open indexes
number of open objects
number of pre-allocated extents
number of user connections
number of worker processes
open index hash spinlock ratio
open index spinlock ratio
open object spinlock ratio
partition groups
partition spinlock ratio
permission cache entries
plan text pipe max messages
print recovery information
process wait events
size of global fixed heap
size of process object heap
size of shared class heap
size of unilib cache
sql text pipe max messages
statement text pipe max messages
tape retention in days
timeslice
additional network memory
allow resource limits
audit queue size
default network memory
disk I/O structures
enable rep agent threads
event buffers per engine
executable codesize + overhead
max cis remote servers
max number network listeners
max roles enabled per user
memory per worker process
number of alarms
number of aux scan descriptors
number of devices
number of languages in cache
number of large I/O buffers
number of locks
number of mailboxes
number of messages
number of open databases
number of open indexes

Get Administrator's Guide to Sybase ASE 15 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.