The following SQL Server configuration parameters (formerly called “configuration variables”) have new names:
Old Name |
New Name |
---|---|
T1204 (trace flag) |
print deadlock information |
T1603 (trace flag) |
allow sql server async i/o |
T1610 (trace flag) |
tcp no delay |
T1611 (trace flag) |
lock shared memory |
allow updates |
allow updates to system tables |
calignment |
memory alignment boundary |
cclkrate |
sql server clock tick length |
cfgcprot |
permission cache entries |
cguardsz |
stack guard size |
cindextrips |
number of index trips |
cmaxnetworks |
max number network listeners |
cmaxscheds |
i/o polling process count |
cnalarm |
number of alarms |
cnblkio |
disk i/o structures |
cnlanginfo |
number of languages in cache |
cnmaxaio_engine |
max async i/os per engine |
cnmaxaio_server |
max async i/os per server |
cnmbox |
number of mailboxes |
cnmsg |
number of messages |
coamtrips |
number of oam trips |
cpreallocext |
number of pre-allocated extents |
cpu flush |
cpu accounting flush interval |
cschedspins |
runnable process search count |
csortbufsize |
number of sort buffers |
csortpgcount |
sort page count (Removed in release11.5.) |
ctimemax |
cpu grace time |
database size |
default database size |
default language |
default language id |
devices |
number of devices |
extent i/o buffers |
number of extent i/o buffers (Removed in 11.5.) |
fillfactor |
default fill factor percent |
i/o flush |
i/o accounting flush interval |
language in cache |
number of languages in cache |
locks |
number of locks |
maximum network packet size |
max network packet size |
memory |
total memory |
mrstart |
shared memory starting address |
nested trigger |
allow nested triggers |
open databases |
number of open databases |
open objects |
number of open objects |
password expiration interval |
systemwide password expiration |
pre-read packets |
remote server pre-read packets |
procedure cache |
procedure cache percent |
recovery flags |
print recovery information |
recovery interval |
recovery interval in minutes |
remote access |
allow remote access |
remote connections |
number of remote connections |
remote logins |
number of remote logins |
remote sites |
number of remote sites |
sql server code size |
executable code size |
tape retention |
tape retention in days |
user connections |
number of user connections |