| Parameter |
Value |
Run |
Min |
Max |
Dynamic |
| abstract plan cache |
0 |
0 |
0 |
0 |
Yes |
| abstract plan dump |
0 |
0 |
0 |
0 |
Yes |
| abstract plan load |
0 |
0 |
0 |
0 |
Yes |
| abstract plan replace |
0 |
0 |
0 |
0 |
Yes |
| additional network memory |
8192 |
8192 |
0 |
2147483647 |
Yes |
| allocate max shared memory |
0 |
0 |
0 |
0 |
Yes |
| allow backward scans |
1 |
1 |
0 |
0 |
Yes |
| allow nested triggers |
1 |
1 |
0 |
1 |
No |
| allow procedure grouping |
1 |
1 |
0 |
0 |
Yes |
| allow remote access |
1 |
1 |
0 |
1 |
Yes |
| allow resource limits |
0 |
0 |
0 |
0 |
No |
| allow sendmsg |
1 |
1 |
0 |
0 |
Yes |
| allow sql server async i/o |
1 |
1 |
0 |
0 |
No |
| allow updates to system tables |
0 |
0 |
0 |
1 |
Yes |
| audit queue size |
100 |
100 |
1 |
65535 |
Yes |
| auditing |
0 |
0 |
0 |
0 |
Yes |
| average cap size |
200 |
200 |
0 |
0 |
No |
| caps per ccb |
50 |
50 |
0 |
0 |
No |
| check password for digit |
0 |
0 |
0 |
0 |
Yes |
| cis bulk insert batch size |
0 |
0 |
0 |
0 |
Yes |
| cis connect timeout |
0 |
0 |
0 |
0 |
Yes |
| cis cursor rows |
50 |
50 |
0 |
0 |
Yes |
| cis packet size |
512 |
512 |
0 |
0 |
Yes |
| cis rpc handling |
0 |
0 |
0 |
0 |
Yes |
| configuration file |
0 |
/sybase/ASE-12_5/IPMA_1.cfg |
0 |
0 |
Yes |
| cpu accounting flush interval |
200 |
200 |
1 |
2147483647 |
Yes |
| cpu grace time |
500 |
500 |
0 |
0 |
Yes |
| curread change w/ open cursors |
1 |
1 |
0 |
0 |
Yes |
| current audit table |
1 |
1 |
0 |
0 |
Yes |
| deadlock checking period |
500 |
500 |
0 |
0 |
Yes |
| deadlock pipe active |
0 |
0 |
0 |
0 |
Yes |
| deadlock pipe max messages |
0 |
0 |
0 |
0 |
Yes |
| deadlock retries |
5 |
5 |
0 |
0 |
Yes |
| default character set id |
1 |
1 |
0 |
255 |
No |
| default database size |
2 |
2 |
2 |
10000 |
Yes |
| default exp_row_size percent |
5 |
5 |
0 |
0 |
Yes |
| default fill factor percent |
0 |
0 |
0 |
100 |
Yes |
| default language id |
0 |
0 |
0 |
2147483647 |
Yes |
| default network packet size |
1024 |
1024 |
512 |
524288 |
No |
| default sortorder id |
54 |
54 |
0 |
255 |
No |
| default unicode sortorder |
binary |
binary |
0 |
0 |
No |
| disable character set conversions |
0 |
0 |
0 |
0 |
No |
| disk i/o structures |
512 |
512 |
0 |
0 |
Yes |
| dtm detach timeout period |
0 |
0 |
0 |
0 |
Yes |
| dtm lock timeout period |
300 |
300 |
0 |
0 |
Yes |
| dump on conditions |
0 |
0 |
0 |
0 |
Yes |
| dynamic allocation on demand |
1 |
1 |
0 |
0 |
Yes |
| enable cis |
1 |
1 |
0 |
0 |
No |
| enable DTM |
0 |
0 |
0 |
0 |
No |
| enable enterprise java beans |
0 |
0 |
0 |
0 |
Yes |
| enable file access |
0 |
0 |
0 |
0 |
Yes |
| enable full-text search |
0 |
0 |
0 |
0 |
Yes |
| enable HA |
0 |
0 |
0 |
0 |
No |
| enable housekeeper GC |
1 |
1 |
0 |
0 |
Yes |
| enable java |
0 |
0 |
0 |
0 |
No |
| enable monitoring |
0 |
0 |
0 |
0 |
Yes |
| enable rep agent threads |
1 |
1 |
0 |
0 |
Yes |
| enable row level access |
0 |
0 |
0 |
0 |
Yes |
| enable sort-merge join and JTC |
0 |
0 |
0 |
0 |
Yes |
| enable ssl |
0 |
0 |
0 |
0 |
No |
| enable surrogate processing |
0 |
0 |
0 |
0 |
Yes |
| enable unicode conversions |
0 |
0 |
0 |
0 |
Yes |
| enable unicode normalization |
0 |
0 |
0 |
0 |
Yes |
| enable xact coordination |
1 |
1 |
0 |
0 |
No |
| errorlog pipe active |
0 |
0 |
0 |
0 |
Yes |
| errorlog pipe max messages |
0 |
0 |
0 |
0 |
Yes |
| esp execution priority |
8 |
8 |
0 |
0 |
Yes |
| esp execution stacksize |
77824 |
77824 |
0 |
0 |
No |
| esp unload dll |
0 |
0 |
0 |
0 |
Yes |
| event buffers per engine |
2000 |
2000 |
0 |
0 |
No |
| event log computer name |
LocalSystem |
LocalSystem |
0 |
0 |
Yes |
| event logging |
1 |
1 |
0 |
0 |
Yes |
| executable codesize + overhead |
0 |
25574 |
0 |
0 |
No |
| global async prefetch limit |
20 |
20 |
0 |
0 |
Yes |
| global cache partition number |
1 |
1 |
0 |
0 |
No |
| heap memory per user |
4096 |
4096 |
0 |
0 |
Yes |
| housekeeper free write percent |
1 |
1 |
0 |
0 |
Yes |
| i/o accounting flush interval |
1000 |
1000 |
1 |
2147483647 |
Yes |
| i/o polling process count |
10 |
10 |
0 |
0 |
Yes |
| identity burning set factor |
1 |
1 |
1 |
9999999 |
No |
| identity grab size |
1 |
1 |
0 |
2147483647 |
Yes |
| license information |
16 |
16 |
0 |
0 |
Yes |
| lock address spinlock ratio |
100 |
100 |
0 |
0 |
No |
| lock hashtable size |
2048 |
2048 |
0 |
0 |
No |
| lock scheme |
allpages |
allpages |
0 |
0 |
Yes |
| lock shared memory |
0 |
0 |
0 |
0 |
No |
| lock spinlock ratio |
85 |
85 |
0 |
0 |
No |
| lock table spinlock ratio |
20 |
20 |
0 |
0 |
No |
| lock wait period |
2147483647 |
2147483647 |
0 |
0 |
Yes |
| log audit logon failure |
0 |
0 |
0 |
0 |
Yes |
| log audit logon success |
0 |
0 |
0 |
0 |
Yes |
| max async i/os per engine |
2147483647 |
2147483647 |
0 |
0 |
No |
| max async i/os per server |
2147483647 |
2147483647 |
0 |
0 |
No |
| max cis remote connections |
0 |
0 |
0 |
0 |
Yes |
| max memory |
800204 |
800204 |
0 |
0 |
Yes |
| max network packet size |
2048 |
2048 |
512 |
524288 |
No |
| max number network listeners |
5 |
5 |
0 |
0 |
No |
| max online engines |
2 |
2 |
1 |
32 |
No |
| max parallel degree |
3 |
3 |
0 |
0 |
Yes |
| max scan parallel degree |
3 |
3 |
0 |
0 |
Yes |
| max SQL text monitored |
2048 |
2048 |
0 |
0 |
No |
| maximum dump conditions |
10 |
10 |
0 |
0 |
No |
| maximum failed logins |
0 |
0 |
0 |
0 |
Yes |
| memory alignment boundary |
2048 |
2048 |
0 |
0 |
No |
| memory per worker process |
10240 |
10240 |
0 |
0 |
Yes |
| minimum password length |
6 |
6 |
0 |
0 |
Yes |
| msg confidentiality reqd |
0 |
0 |
0 |
0 |
Yes |
| msg integrity reqd |
0 |
0 |
0 |
0 |
Yes |
| number of alarms |
40 |
40 |
0 |
0 |
Yes |
| number of aux scan descriptors |
200 |
200 |
0 |
0 |
Yes |
| number of ccbs |
0 |
0 |
0 |
0 |
No |
| number of devices |
25 |
25 |
4 |
256 |
Yes |
| number of dtx participants |
500 |
500 |
0 |
0 |
Yes |
| number of engines at startup |
2 |
2 |
1 |
32 |
No |
| number of histogram steps |
20 |
20 |
0 |
0 |
Yes |
| number of index trips |
0 |
0 |
0 |
0 |
Yes |
| number of java sockets |
0 |
0 |
0 |
0 |
Yes |
| number of large i/o buffers |
30 |
30 |
0 |
0 |
No |
| number of locks |
1000000 |
1000000 |
5000 |
2147483647 |
Yes |
| number of mailboxes |
30 |
30 |
0 |
0 |
Yes |
| number of messages |
64 |
64 |
0 |
0 |
Yes |
| number of oam trips |
0 |
0 |
0 |
0 |
Yes |
| number of open databases |
30 |
30 |
5 |
2147483647 |
Yes |
| number of open indexes |
1500 |
1500 |
0 |
0 |
Yes |
| number of open objects |
15000 |
15000 |
100 |
2147483647 |
Yes |
| number of pre-allocated extents |
2 |
2 |
0 |
0 |
Yes |
| number of remote connections |
20 |
20 |
0 |
2147483647 |
No |
| number of remote logins |
20 |
20 |
0 |
2147483647 |
No |
| number of remote sites |
10 |
10 |
0 |
2147483647 |
No |
| number of sort buffers |
500 |
500 |
0 |
0 |
Yes |
| number of user connections |
120 |
120 |
5 |
2147483647 |
Yes |
| number of worker processes |
10 |
10 |
0 |
0 |
Yes |
| o/s file descriptors |
0 |
1024 |
0 |
0 |
No |
| object lockwait timing |
0 |
0 |
0 |
0 |
Yes |
| open index hash spinlock ratio |
100 |
100 |
0 |
0 |
Yes |
| open index spinlock ratio |
100 |
100 |
0 |
0 |
Yes |
| open object spinlock ratio |
100 |
100 |
0 |
0 |
Yes |
| page lock promotion HWM |
200 |
200 |
200 |
2147483647 |
Yes |
| page lock promotion LWM |
200 |
200 |
0 |
0 |
Yes |
| page lock promotion PCT |
100 |
100 |
0 |
0 |
Yes |
| page utilization percent |
95 |
95 |
0 |
0 |
Yes |
| partition groups |
1024 |
1024 |
0 |
0 |
Yes |
| partition spinlock ratio |
10 |
10 |
0 |
0 |
Yes |
| per object statistics active |
0 |
0 |
0 |
0 |
Yes |
| performance monitoring option |
0 |
0 |
0 |
0 |
Yes |
| permission cache entries |
15 |
15 |
0 |
0 |
Yes |
| plan text pipe active |
0 |
0 |
0 |
0 |
Yes |
| plan text pipe max messages |
0 |
0 |
0 |
0 |
Yes |
| print deadlock information |
1 |
1 |
0 |
0 |
Yes |
| print recovery information |
0 |
0 |
0 |
1 |
Yes |
| procedure cache size |
28796 |
28796 |
0 |
0 |
Yes |
| process wait events |
0 |
0 |
0 |
0 |
Yes |
| read committed with lock |
0 |
0 |
0 |
0 |
Yes |
| recovery interval in minutes |
1 |
1 |
1 |
32767 |
Yes |
| remote server pre-read packets |
3 |
3 |
0 |
2147483647 |
No |
| row lock promotion HWM |
200 |
200 |
0 |
0 |
Yes |
| row lock promotion LWM |
200 |
200 |
0 |
0 |
Yes |
| row lock promotion PCT |
100 |
100 |
0 |
0 |
Yes |
| runnable process search count |
1000 |
1000 |
0 |
0 |
Yes |
| sampling percent |
0 |
0 |
0 |
0 |
Yes |
| secure default login |
guest |
guest |
0 |
0 |
Yes |
| select on syscomments.text |
1 |
1 |
0 |
0 |
Yes |
| shared memory starting address |
0 |
0 |
0 |
0 |
No |
| size of auto identity column |
10 |
10 |
1 |
38 |
Yes |
| size of global fixed heap |
300 |
300 |
0 |
0 |
Yes |
| size of process object heap |
3000 |
3000 |
0 |
0 |
Yes |
| size of shared class heap |
3072 |
3072 |
0 |
0 |
Yes |
| size of unilib cache |
0 |
0 |
0 |
0 |
Yes |
| SQL batch capture |
0 |
0 |
0 |
0 |
Yes |
| SQL Perfmon Integration |
1 |
1 |
0 |
0 |
No |
| sql server clock tick length |
100000 |
100000 |
0 |
0 |
No |
| sql text pipe active |
0 |
0 |
0 |
0 |
Yes |
| sql text pipe max messages |
0 |
0 |
0 |
0 |
Yes |
| stack guard size |
4096 |
4096 |
0 |
0 |
No |
| stack size |
86016 |
86016 |
20480 |
2147483647 |
No |
| start mail session |
0 |
0 |
0 |
0 |
Yes |
| statement pipe active |
0 |
0 |
0 |
0 |
Yes |
| statement pipe max messages |
0 |
0 |
0 |
0 |
Yes |
| statement statistics active |
0 |
0 |
0 |
0 |
Yes |
| strict dtm enforcement |
0 |
0 |
0 |
0 |
No |
| suspend audit when device full |
1 |
1 |
0 |
0 |
Yes |
| syb_sendmsg port number |
56514 |
56514 |
0 |
0 |
No |
| systemwide password expiration |
0 |
0 |
0 |
32767 |
Yes |
| tape retention in days |
0 |
0 |
0 |
365 |
Yes |
| tcp no delay |
1 |
1 |
0 |
0 |
No |
| text prefetch size |
16 |
16 |
0 |
0 |
Yes |
| time slice |
200 |
200 |
50 |
1000 |
Yes |
| total data cache size |
0 |
812692 |
0 |
0 |
No |
| total logical memory |
609095 |
609095 |
3850 |
2147483647 |
Yes |
| total physical memory |
0 |
609096 |
0 |
0 |
No |
| unified login required |
0 |
0 |
0 |
0 |
Yes |
| upgrade version |
12500 |
12500 |
0 |
2147483647 |
Yes |
| use security services |
0 |
0 |
0 |
0 |
No |
| user log cache size |
4096 |
4096 |
0 |
0 |
No |
| user log cache spinlock ratio |
20 |
20 |
0 |
0 |
Yes |
| wait event timing |
0 |
0 |
0 |
0 |
Yes |
| xact coordination interval |
60 |
60 |
0 |
0 |
Yes |
| xp_cmdshell context |
0 |
0 |
0 |
0 |
Yes |