The following lists the Adaptive Server configuration parameters alphabetically.
“abstract plan cache”
“abstract plan dump”
“abstract plan load”
“abstract plan replace”
“additional network 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”
“auditing”
“audit queue size”
“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”
“current audit table”
“deadlock checking period”
“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”
“disable character set conversions”
“disk i/o structures”
“dtm detach timeout period”
“dtm lock timeout period”
“dump on conditions”
“enable full-text search”
“enable cis”
“enable DTM”
“enable housekeeper GC”
“enable HA”
“enable java”
“enable enterprise java beans”
“enable file access”
“enable rep agent threads”
“enable ssl”
“enable sort-merge joins and JTC”
“enable surrogate processing”
“enable unicode conversion”
“enable unicode normalization”
“enable xact coordination”
“esp execution priority”
“esp execution stacksize”
“esp unload dll”
“event buffers per engine”
“event log computer name (Windows NT only)”
“event logging (Windows NT only)”
“executable codesize + overhead”
“global async prefetch limit”
“global cache partition number”
“housekeeper free write percent”
“i/o accounting flush interval”
“i/o polling process count”
“identity burning set factor”
“identity grab size”
“license information”
“lock address spinlock ratio”
“lock hashtable size”
“lock shared memory”
“lock scheme”
“lock spinlock ratio”
“lock table spinlock ratio”
“lock wait period”
“log audit logon failure”
“log audit logon success”
“max async i/os per engine”
“max async i/os per server”
“max cis remote connections”
“max network packet size”
“max number network listeners”
“max online engines”
“max parallel degree”
“max scan parallel degree”
“max SQL text monitored”
“maximum dump conditions”
“memory alignment boundary”
“memory per worker process”
“msg confidentiality reqd”
“msg integrity reqd”
“number of alarms”
“number of aux scan descriptors”
“number of devices”
“number of dtx participants”
“number of index trips”
“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 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”
“open index hash spinlock ratio”
“open index spinlock ratio”
“open object spinlock ratio”
“o/s file descriptors”
“page lock promotion HWM”
“page lock promotion LWM”
“page lock promotion PCT”
“page utilization percent”
“partition groups”
“partition spinlock ratio”
“permission cache entries”
“print deadlock information”
“print recovery information”
“procedure cache size”
“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”
“runnable process search count”
“secure default login”
“select on syscomments.text column”
“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 Perfmon Integration (Windows NT only)”
“sql server clock tick length”
“stack guard size”
“stack size”
“start mail session (Windows NT only)”
“strict dtm enforcement”
“suspend audit when device full”
“syb_sendmsg port number”
“systemwide password expiration”
“tape retention in days”
“tcp no delay”
“text prefetch size”
“time slice”
“total data cache size”
“total logical memory”
“txn to pss ratio”
“unified login required (Windows NT only)”
“upgrade version”
“user log cache size”
“user log cache spinlock ratio”
“use security services (Windows NT only)”
“xact coordination interval”
“xp_cmdshell context”
