Supported Sybase ASE Configuration Parameters
Go Up to Parameters, Arguments, Options, and Variables Appendix
The following parameters are available from the Explorer’s Configuration node. For information on working with these parameters, see Working with Configuration/initialization Parameters.
SQL Perfmon Integration |
SQL batch capture |
abstract plan cache |
abstract plan dump |
abstract plan load |
abstract plan replace |
additional network memory |
allocate max shared memory |
allow backward scans |
allow nested triggers |
allow procedure grouping |
allow remote access |
allow resource limits |
allow sendmsg |
allow sql server async i/o |
allow updates to system tables |
audit queue size |
auditing |
average cap size |
'caps per ccb |
check password for digit |
cis bulk insert array size |
cis bulk insert batch size |
cis connect timeout |
cis cursor rows |
cis packet size |
cis rpc handling |
configuration file |
cpu accounting flush interval |
cpu grace time' |
curread change w/ open cursors |
current audit table |
deadlock checking period |
deadlock pipe active |
deadlock pipe max messages |
deadlock retries |
default character set id |
default database size |
default exp_row_size percent |
default fill factor percent |
default language id |
default network packet size |
default sortorder id |
default unicode sortorder |
default xml sortorder |
disable character set conversions |
disable disk mirroring |
disk i/o structures |
dtm detach timeout period |
dtm lock timeout period |
dump on conditions |
dynamic allocation on demand |
enable DTM |
enable HA |
enable cis |
enable enterprise java beans |
enable file access |
enable full-text search |
enable housekeeper GC |
enable java |
enable job scheduler |
enable ldap user auth |
enable metrics capture |
enable monitoring |
enable pam user auth |
enable real time messaging |
enable rep agent threads |
enable row level access |
enable semantic partitioning |
enable snmp |
enable sort-merge join and JTC |
enable ssl |
enable surrogate processing |
enable unicode conversions |
enable unicode normalization |
enable webservices |
enable xact coordination |
enable xml |
errorlog pipe active |
errorlog pipe max messages |
esp execution priority |
esp execution stacksize |
esp unload dll |
event buffers per engine |
event log computer name |
event logging |
executable codesize + overhead |
extended cache size |
global async prefetch limit |
global cache partition number |
heap memory per user |
histogram tuning factor |
housekeeper free write percent |
i/o accounting flush interval |
i/o batch size |
i/o polling process count |
identity burning set factor |
identity grab size |
job scheduler interval |
job scheduler tasks |
license information |
lock address spinlock ratio |
lock hashtable size |
lock scheme |
lock shared memory |
lock spinlock ratio |
lock table spinlock ratio |
lock wait period |
log audit logon failure |
log audit logon success |
max SQL text monitored |
max async i/os per engine |
max async i/os per server |
max cis remote connections |
max concurrently recovered db |
max memory |
max native threads per engine |
max network packet size |
max number network listeners |
max online engines |
max parallel degree |
max repartition degree |
max resource granularity |
max scan parallel degree |
maximum dump conditions |
maximum failed logins |
maximum job output |
memory alignment boundary |
memory per worker process |
messaging memory |
minimum password length |
msg confidentiality reqd |
msg integrity reqd |
number of alarms |
number of aux scan descriptors |
number of ccbs |
number of checkpoint tasks |
number of devices |
number of dtx participants |
number of dump threads |
number of engines at startup |
number of histogram steps |
number of index trips |
number of java sockets |
number of large i/o buffers |
number of locks |
number of mailboxes |
number of messages |
number of oam trips |
number of open databases |
number of open indexes |
number of open objects |
number of open partitions |
number of pre-allocated extents |
number of remote connections |
number of remote logins |
number of remote sites |
number of sort buffers |
number of user connections |
number of worker processes |
o/s file descriptors |
object lockwait timing |
open index hash spinlock ratio |
open index spinlock ratio |
open object spinlock ratio |
optimization goal |
optimization timeout limit |
page lock promotion HWM |
page lock promotion LWM |
page lock promotion PCT |
page utilization percent |
partition groups |
partition spinlock ratio |
per object statistics active |
percent database for history |
percent database for output |
percent history free |
percent output free |
performance monitoring option |
permission cache entries |
plan text pipe active |
plan text pipe max messages |
print deadlock information |
print recovery information |
procedure cache size |
process wait events |
read committed with lock |
recovery interval in minutes |
remote server pre-read packets |
row lock promotion HWM |
row lock promotion LWM |
row lock promotion PCT |
rtm thread idle wait period |
runnable process search count |
sampling percent |
secure default login |
select on syscomments.text |
send doneinproc tokens |
shared memory starting address |
size of auto identity column |
size of global fixed heap |
size of process object heap |
size of shared class heap |
size of unilib cache |
sql server clock tick length |
sql text pipe active |
sql text pipe max messages |
stack guard size |
stack size |
start mail session |
statement cache size |
statement pipe active |
statement pipe max messages |
statement statistics active |
strict dtm enforcement |
suspend audit when device full |
syb_sendmsg port number |
sysstatistics flush interval |
systemwide password expiration |
tape retention in days |
tcp no delay |
text prefetch size |
time slice |
total data cache size |
total logical memory |
total physical memory |
txn to pss ratio |
unified login required |
upgrade version |
use security services |
user log cache size |
user log cache spinlock ratio |
wait event timing |
xact coordination interval |
xp_cmdshell context |