New configuration parameters

Release 11.0 introduced a number of new configuration parameters listed in Table 6-9. See Chapter 11, “Setting Configuration Parameters,” in the System Administration Guide for a complete description of these parameters.

Table 6-9: New SQL Server configuration parameters for release 11.0

address lock spinlock ratio

configuration file

deadlock checking period

deadlock retries

event buffers per engine

freelock transfer block size

housekeeper free write percent

identity grab size

lock promotion HWM

lock promotion LWM

lock promotion PCT

max engine freelocks

o/s async i/o enabled

o/s file descriptors

page lock spinlock ratio

page utilization percent

partition groups

partition spinlock ratio

size of auto identity column

table lock spinlock ratio

total data cache size

user lock cache size

user lock cache spinlock ratio