No new writeups yet.
10401 10 additional network memory allocates additional memory for clients which request packet sizes that are larger than the default packet size for the server.
10402 10 lock address spinlock ratio specifies the number of address lock buckets in the address locks hash table which are protected by each spinlock (buckets per spinlock).
10403 10 allow nested triggers is a toggle that controls the use of nested triggers. When the value is set to 1, data modifications made by triggers can fire other triggers.
10404 10 allow remote access determines whether users from remote servers can access this ASE. The default is 1, to allow ASE to communicate with Backup Server.
10405 10 allow sql server async i/o is a toggle that enables ASE to run with asynchronous disk I/O.
10406 10 allow updates to system tables allows system tables to be updated directly. The default is 0 (off).
10407 10 audit queue size determines the number of audit records that the audit queue can hold. The default is 100.
10408 10 configuration file specifies the location of the configuration file you want to use.
10409 10 cpu accounting flush interval specifies how many machine clock ticks to accumulate before adding cpu usage data to syslogins for use in chargeback accounting statistics.
10410 10 cpu grace time specifies the maximum amount of time (in milliseconds) a user process can run without yielding the CPU before ASE infects it.
10411 10 deadlock checking period specifies the minimum amount of time (in milliseconds) a process must wait for a lock before ASE initiates a deadlock check.
10412 10 deadlock retries specifies the number of times a transaction will retry to acquire a lock after it has become a deadlock victim.
10413 10 default character set id is the number of the default character set used by the server.
10414 10 default database size sets the default number of megabytes allocated to each new user database. The default run value is 2 (megabytes)
10415 10 default fill factor percent sets how full ASE makes each page when creating a new index on existing data (unless user gives other value in create index statement).
10416 10 default language id is the number of the language that is used to display system messages unless a user has chosen another language from those available on the server.
10417 10 default network packet size sets the default size of network packets for all users on ASE.
10418 10 default sortorder id is the number of the current default sortorder on ASE. Do not change this parameter. See the System Administration Guide for more information.
10419 10 disk i/o structures specifies the initial number of disk I/O control blocks ASE allocates on startup.
10420 10 event buffers per engine specifies the number of events per ASE engine that can be simultaneously monitored. Events are used for observing ASE performance.
10421 10 executable code size reports the size of the ASE executable.
10423 10 housekeeper free write percent sets the maximum percentage that database writes can increase because of free writes started by the housekeeper process.
10424 10 i/o accounting flush interval specifies how many disk I/Os to accumulate before flushing the data to syslogins for use in chargeback accounting.
10425 10 i/o polling process count specifies the number of tasks the scheduler will run before checking for disk and/or network I/O completions.
10426 10 identity burning set factor sets the percentage of potential IDENTITY column values made available in each block.
10427 10 identity grab size allows each ASE process to reserve a block of IDENTITY column values for inserts into tables that have an IDENTITY column.
10428 10 page lock promotion HWM sets the maximum number of page locks allowed before ASE escalates to a table lock. The default value is 200.
10429 10 page lock promotion LWM sets the minimum number of page locks allowed before ASE escalates to a table lock. The default value is 200.
10430 10 page lock promotion PCT sets the percentage of page locks allowed before ASE escalates to a table lock. The default value is 100.
10431 10 lock shared memory disallows swapping of ASE pages to disk, and allowing the operating system kernel to avoid the server's internal page locking code.
10432 10 max async i/o's per engine specifies the maximum number of asynchronous disk I/O requests that can be outstanding for a single engine at one time.
10433 10 max async i/o's per server specifies the maximum number of asynchronous disk I/O requests that can be outstanding for ASE at one time.
10435 10 max network packet size sets the maximum network packet size that a client program can request.
10436 10 max number of network listeners specifies the maximum number of network listeners that can be open at one time.
10437 10 max online engines controls the number of engines in a symmetric multiprocessor environment.
10438 10 memory alignment boundary determines on which boundary buffer caches are aligned.
10440 10 number of alarms specifies the number of alarms allocated by ASE. Alarms are used with the Transact-SQL waitfor command.
10441 10 number of devices controls the number of database devices ASE can use. It does not include devices used for database dumps.
10442 10 number of extent i/o buffers allocates the specified number of extents (8 data pages) for use by create index. Do not set this value to more than 100.
10443 10 number of index trips specifies the number of times an aged index page recycles itself onto the MRU chain.
10445 10 number of locks sets the number of available locks. The default run value is 10000.
10446 10 number of mailboxes sets the number of mailbox structures ASE allocates on start-up. Mailboxes are use for process-to-process communication and synchronization.
10447 10 number of messages specifies the number of message structures allocated by ASE at start-up time. Messages are used in conjunction with mailboxes for
process-to-process communication and synchronization.
10448 10 number of oam trips specifies the number of times an aged OAM page recycles itself onto the MRU chain.
10449 10 number of open databases sets the maximum number of databases that can be open at one time on ASE. The default run value is 12.
10450 10 number of open objects sets the maximum number of database objects that can be open at one time on ASE. The default run value is 500.
10451 10 number of preallocated extents specifies the number of extent structures allocated in a single trip to the page manager.
10452 10 number of remote connections controls the limit on active connections initiated to and from this ASE. The default is 20.
10453 10 number of remote logins controls the number of active user connections from this ASE to remote servers. The default is 20.
10454 10 number of remote sites controls the number of simultaneous remote sites that can access this ASE. The default is 10.
10455 10 number of sort buffers specifies the number of buffers used to hold pages read from input tables.
10456 10 number of user connections sets the maximum number of user connections that can be connected to ASE at one time.
10457 10 page lock spinlock ratio specifies the ratio of spinlocks protecting the internal page locks hash table.
10458 10 page utilization percent controls when ASE performs an OAM (Object Allocation Map) scan to find unused pages. The default run value is 95.
10459 10 partition groups sets how many partition groups to allocate for the server. Partition groups are used by ASE to control access to individual partitions of tables.
10460 10 partition spinlock ratio sets the number of partition caches each spinlock protects. These spinlocks keep processes from using partition caches used by other processes.
10461 10 permission cache entries determines the number of cache protectors per task.
10462 10 print deadlock information enables printing of deadlock information to the error log.
10463 10 print recovery information determines what information ASE displays on the console during recovery.
10464 10 procedure cache percent specifies the amount of memory allocated to the procedure cache after ASE's memory needs are met. The default run value is 20.
10465 10 recovery interval in minutes sets the maximum time per database that ASE uses to complete its recovery procedures in case of a system failure.
10466 10 remote server pre-read packets controls the number of packets that a site handler will pre-read in connections with remote servers. The default is 3.
10467 10 runnable process search count specifies the number of times an engine will loop looking for a runnable task before relinquishing the CPU.
10468 10 sort page count specifies the maximum amount of memory a sort operation can use.
10469 10 sql server clock tick length specifies the duration of the server's clock tick, in microseconds.
10470 10 stack guard size specifies the size of the stack guard area.
10471 10 stack size sets the size of ASE's execution stack.
10472 0 This option specifies the number of days that passwords remain in effect after they are changed. The default is 0 (passwords do not expire).
10473 10 lock table spinlock ratio specifies the number of table lock buckets in the table lock hash table which are protected by each spinlock (buckets per spinlock).
10474 10 tape retention in days sets the number of days you want to retain each tape after it has been used for a database or transaction log dump.
10475 10 tcp no delay disables TCP packet batching.
10476 10 time slice sets the number of milliseconds that ASE's scheduler allows a user process to run. The default run value is 100 milliseconds.
10477 10 total data cache size represents the amount of memory currently available for use as a data cache. It is a calculated value that is not directly user-configurable.
10478 10 The run value of 'total logical memory' indicates the size of memory required to satisfy the current configuration.
10479 10 upgrade version is changed by the upgrade program provided with new releases.
10480 10 user log cache size specifies the size (in bytes) for each user's log cache.
10481 10 user log cache spinlock ratio specifies the number of user log caches per user log cache spinlock.
10482 10 shared memory starting address determines the virtual address at which ASE starts its shared memory region. Most users do not need to modify this.
10483 10 size of auto identity column sets the precision of IDENTITY columns automatically created with the sp_dboption 'auto identity' option.
10485 10 os file descriptors is a read-only parameter that indicates how many file descriptors have been allocated to ASE. It is not user-configurable.
10486 10 Allow-limits allows the Resource Governor feature to be used by SAs. Default is 0 (off); static.
10487 10 number of auxiliary scan descriptors sets the maximum number of auxiliary scan descriptors that can be shared among all connections at one time. The default run value is 200.
10488 10 number of open indexes sets the maximum number of indexes that can be open at one time on ASE. The default value is 500.
10489 10 open object spinlock ratio specifies the number of open objects protected by one spinlock. The default value is 100.
10490 10 open index hash spinlock ratio specifies the number of internal hash tables for open indexes protected by one spinlock. The default value is 100.
10491 10 open index spinlock ratio specifies the number of open indexes protected by one spinlock. The default value is 100.
10492 10 enable cis specifies whether Component Integration Services is loaded when the server is started. The default is 1.
10493 10 cis connect timeout specifies the number of seconds to wait for a connect request to a remote server to complete.
10494 10 cis bulk insert batch size specifies the number of rows in a bulk copy batch when performing a SELECT INTO operation.
10495 10 max cis remote connections specifies the maximum number of connections to remote servers that can be active at one time.
10497 10 cis packet size specifies the maximum size of a network packet.
10498 10 cis cursor rows specifies the maximum number of rows that will be returned in response to a single fetch operation.
10499 10 CIS idle timeout specifies the number of seconds to wait before terminating an idle connection with a remote server.