sybase configure 配置信息
EXEC sp_configure 'abstract plan cache',0
go
EXEC sp_configure 'abstract plan dump',0
go
EXEC sp_configure 'abstract plan load',0
go
EXEC sp_configure 'abstract plan replace',0
go
EXEC sp_configure 'additional network memory',10240
go
EXEC sp_configure 'allocate max shared memory',0
go
EXEC sp_configure 'allow backward scans',1
go
EXEC sp_configure 'allow nested triggers',1
go
EXEC sp_configure 'allow procedure grouping',1
go
EXEC sp_configure 'allow remote access',1
go
EXEC sp_configure 'allow resource limits',0
go
EXEC sp_configure 'allow sendmsg',0
go
EXEC sp_configure 'allow sql server async i/o',1
go
EXEC sp_configure 'allow updates to system tables',0
go
EXEC sp_configure 'audit queue size',100
go
EXEC sp_configure 'auditing',0
go
EXEC sp_configure 'average cap size',200
go
EXEC sp_configure 'caps per ccb',50
go
EXEC sp_configure 'check password for digit',0
go
EXEC sp_configure 'cis bulk insert array size',50
go
EXEC sp_configure 'cis bulk insert batch size',0
go
EXEC sp_configure 'cis connect timeout',0
go
EXEC sp_configure 'cis cursor rows',50
go
EXEC sp_configure 'cis packet size',512
go
EXEC sp_configure 'cis rpc handling',0
go
--EXEC sp_configure 'configuration file',0,'F:\sybase\sybase_cs.cfg'
--go
EXEC sp_configure 'cpu accounting flush interval',200
go
EXEC sp_configure 'cpu grace time',500
go
EXEC sp_configure 'curread change w/ open cursors',1
go
EXEC sp_configure 'current audit table',1
go
EXEC sp_configure 'deadlock checking period',500
go
EXEC sp_configure 'deadlock pipe active',1
go
EXEC sp_configure 'deadlock pipe max messages',1000
go
EXEC sp_configure 'deadlock retries',5
go
EXEC sp_configure 'default character set id',2
go
EXEC sp_configure 'default database size',8
go
EXEC sp_configure 'default exp_row_size percent',5
go
EXEC sp_configure 'default fill factor percent',0
go
EXEC sp_configure 'default language id',0
go
EXEC sp_configure 'default network packet size',512
go
EXEC sp_configure 'default sortorder id',48
go
EXEC sp_configure 'default unicode sortorder',0,'binary'
go
EXEC sp_configure 'disable character set conversions',0
go
EXEC sp_configure 'disable disk mirroring',1
go
EXEC sp_configure 'disk i/o structures',256
go
EXEC sp_configure 'dtm detach timeout period',0
go
EXEC sp_configure 'dtm lock timeout period',300
go
EXEC sp_configure 'dump on conditions',0
go
EXEC sp_configure 'dynamic allocation on demand',1
go
EXEC sp_configure 'enable cis',1
go
EXEC sp_configure 'enable DTM',0
go
EXEC sp_configure 'enable enterprise java beans',0
go
EXEC sp_configure 'enable file access',0
go
EXEC sp_configure 'enable full-text search',0
go
EXEC sp_configure 'enable HA',0
go
EXEC sp_configure 'enable housekeeper GC',1
go
EXEC sp_configure 'enable java',0
go
EXEC sp_configure 'enable job scheduler',0
go
EXEC sp_configure 'enable ldap user auth',0
go
EXEC sp_configure 'enable monitoring',1
go
EXEC sp_configure 'enable pam user auth',0
go
EXEC sp_configure 'enable real time messaging',0
go
EXEC sp_configure 'enable rep agent threads',0
go
EXEC sp_configure 'enable row level access',0
go
EXEC sp_configure 'enable snmp',0
go
EXEC sp_configure 'enable sort-merge join and JTC',0
go
EXEC sp_configure 'enable ssl',0
go
EXEC sp_configure 'enable surrogate processing',1
go
EXEC sp_configure 'enable unicode conversions',0
go
EXEC sp_configure 'enable unicode normalization',1
go
EXEC sp_configure 'enable webservices',0
go
EXEC sp_configure 'enable xact coordination',1
go
EXEC sp_configure 'enable xml',0
go
EXEC sp_configure 'errorlog pipe active',1
go
EXEC sp_configure 'errorlog pipe max messages',1000
go
EXEC sp_configure 'esp execution priority',8
go
EXEC sp_configure 'esp execution stacksize',34816
go
EXEC sp_configure 'esp unload dll',0
go
EXEC sp_configure 'event buffers per engine',100
go
EXEC sp_configure 'event log computer name',0,'LocalSystem'
go
EXEC sp_configure 'event logging',1
go
EXEC sp_configure 'executable codesize + overhead',60204
go
EXEC sp_configure 'extended cache size',0
go
EXEC sp_configure 'global async prefetch limit',10
go
EXEC sp_configure 'global cache partition number',1
go
EXEC sp_configure 'heap memory per user',4096
go
EXEC sp_configure 'histogram tuning factor',1
go
EXEC sp_configure 'housekeeper free write percent',1
go
EXEC sp_configure 'i/o accounting flush interval',1000
go
EXEC sp_configure 'i/o batch size',100
go
EXEC sp_configure 'i/o polling process count',10
go
EXEC sp_configure 'identity burning set factor',5000
go
EXEC sp_configure 'identity grab size',1
go
EXEC sp_configure 'job scheduler interval',1
go
EXEC sp_configure 'job scheduler tasks',32
go
EXEC sp_configure 'license information',25
go
EXEC sp_configure 'lock address spinlock ratio',100
go
EXEC sp_configure 'lock hashtable size',2048
go
EXEC sp_configure 'lock scheme',0,'allpages'
go
EXEC sp_configure 'lock shared memory',0
go
EXEC sp_configure 'lock spinlock ratio',85
go
EXEC sp_configure 'lock table spinlock ratio',20
go
EXEC sp_configure 'lock wait period',2147483647
go
EXEC sp_configure 'log audit logon failure',0
go
EXEC sp_configure 'log audit logon success',0
go
EXEC sp_configure 'max async i/os per engine',2147483647
go
EXEC sp_configure 'max async i/os per server',2147483647
go
EXEC sp_configure 'max cis remote connections',0
go
EXEC sp_configure 'max concurrently recovered db',0
go
EXEC sp_configure 'max memory',2097151
go
EXEC sp_configure 'max network packet size',6144
go
EXEC sp_configure 'max number network listeners',5
go
EXEC sp_configure 'max online engines',4
go
EXEC sp_configure 'max parallel degree',1
go
EXEC sp_configure 'max scan parallel degree',1
go
EXEC sp_configure 'max SQL text monitored',256
go
EXEC sp_configure 'maximum dump conditions',10
go
EXEC sp_configure 'maximum failed logins',0
go
EXEC sp_configure 'maximum job output',32768
go
EXEC sp_configure 'memory alignment boundary',8192
go
EXEC sp_configure 'memory per worker process',1024
go
EXEC sp_configure 'messaging memory',400
go
EXEC sp_configure 'minimum password length',6
go
EXEC sp_configure 'msg confidentiality reqd',0
go
EXEC sp_configure 'msg integrity reqd',0
go
EXEC sp_configure 'number of alarms',40
go
EXEC sp_configure 'number of aux scan descriptors',200
go
EXEC sp_configure 'number of ccbs',0
go
EXEC sp_configure 'number of checkpoint tasks',1
go
EXEC sp_configure 'number of devices',10
go
EXEC sp_configure 'number of dtx participants',500
go
EXEC sp_configure 'number of dump threads',1
go
EXEC sp_configure 'number of engines at startup',4
go
EXEC sp_configure 'number of histogram steps',20
go
EXEC sp_configure 'number of index trips',0
go
EXEC sp_configure 'number of java sockets',0
go
EXEC sp_configure 'number of large i/o buffers',6
go
EXEC sp_configure 'number of locks',100000
go
EXEC sp_configure 'number of mailboxes',30
go
EXEC sp_configure 'number of messages',64
go
EXEC sp_configure 'number of oam trips',0
go
EXEC sp_configure 'number of open databases',12
go
EXEC sp_configure 'number of open indexes',10000
go
EXEC sp_configure 'number of open objects',50000
go
EXEC sp_configure 'number of pre-allocated extents',2
go
EXEC sp_configure 'number of remote connections',20
go
EXEC sp_configure 'number of remote logins',20
go
EXEC sp_configure 'number of remote sites',10
go
EXEC sp_configure 'number of sort buffers',500
go
EXEC sp_configure 'number of user connections',500
go
EXEC sp_configure 'number of worker processes',0
go
EXEC sp_configure 'o/s file descriptors',100000
go
EXEC sp_configure 'object lockwait timing',1
go
EXEC sp_configure 'open index hash spinlock ratio',100
go
EXEC sp_configure 'open index spinlock ratio',100
go
EXEC sp_configure 'open object spinlock ratio',100
go
EXEC sp_configure 'page lock promotion HWM',200
go
EXEC sp_configure 'page lock promotion LWM',200
go
EXEC sp_configure 'page lock promotion PCT',100
go
EXEC sp_configure 'page utilization percent',95
go
EXEC sp_configure 'partition groups',1024
go
EXEC sp_configure 'partition spinlock ratio',10
go
EXEC sp_configure 'per object statistics active',1
go
EXEC sp_configure 'percent database for history',20
go
EXEC sp_configure 'percent database for output',30
go
EXEC sp_configure 'percent history free',30
go
EXEC sp_configure 'percent output free',50
go
EXEC sp_configure 'performance monitoring option',0
go
EXEC sp_configure 'permission cache entries',15
go
EXEC sp_configure 'plan text pipe active',1
go
EXEC sp_configure 'plan text pipe max messages',1000
go
EXEC sp_configure 'print deadlock information',0
go
EXEC sp_configure 'print recovery information',0
go
EXEC sp_configure 'procedure cache size',102400
go
EXEC sp_configure 'process wait events',1
go
EXEC sp_configure 'read committed with lock',0
go
EXEC sp_configure 'recovery interval in minutes',5
go
EXEC sp_configure 'remote server pre-read packets',3
go
EXEC sp_configure 'row lock promotion HWM',200
go
EXEC sp_configure 'row lock promotion LWM',200
go
EXEC sp_configure 'row lock promotion PCT',100
go
EXEC sp_configure 'runnable process search count',2000
go
EXEC sp_configure 'sampling percent',0
go
EXEC sp_configure 'secure default login',0,'guest'
go
EXEC sp_configure 'select on syscomments.text',1
go
EXEC sp_configure 'send doneinproc tokens',1
go
EXEC sp_configure 'shared memory starting address',0
go
EXEC sp_configure 'size of auto identity column',10
go
EXEC sp_configure 'size of global fixed heap',150
go
EXEC sp_configure 'size of process object heap',1500
go
EXEC sp_configure 'size of shared class heap',1536
go
EXEC sp_configure 'size of unilib cache',0
go
EXEC sp_configure 'SQL batch capture',1
go
EXEC sp_configure 'SQL Perfmon Integration',1
go
EXEC sp_configure 'sql server clock tick length',100000
go
EXEC sp_configure 'sql text pipe active',1
go
EXEC sp_configure 'sql text pipe max messages',1000
go
EXEC sp_configure 'stack guard size',16384
go
EXEC sp_configure 'stack size',41984
go
EXEC sp_configure 'start mail session',0
go
EXEC sp_configure 'statement cache size',0
go
EXEC sp_configure 'statement pipe active',1
go
EXEC sp_configure 'statement pipe max messages',1000
go
EXEC sp_configure 'statement statistics active',1
go
EXEC sp_configure 'strict dtm enforcement',0
go
EXEC sp_configure 'suspend audit when device full',1
go
EXEC sp_configure 'syb_sendmsg port number',0
go
EXEC sp_configure 'systemwide password expiration',0
go
EXEC sp_configure 'tape retention in days',0
go
EXEC sp_configure 'tcp no delay',1
go
EXEC sp_configure 'text prefetch size',16
go
EXEC sp_configure 'time slice',100
go
EXEC sp_configure 'total data cache size',968450
go
EXEC sp_configure 'total logical memory',719811
go
EXEC sp_configure 'total physical memory',719877
go
EXEC sp_configure 'txn to pss ratio',16
go
EXEC sp_configure 'unified login required',0
go
EXEC sp_configure 'upgrade version',12500
go
EXEC sp_configure 'use security services',0
go
EXEC sp_configure 'user log cache size',8192
go
EXEC sp_configure 'user log cache spinlock ratio',20
go
EXEC sp_configure 'wait event timing',1
go
EXEC sp_configure 'xact coordination interval',60
go
EXEC sp_configure 'xp_cmdshell context',1
go
go
EXEC sp_configure 'abstract plan dump',0
go
EXEC sp_configure 'abstract plan load',0
go
EXEC sp_configure 'abstract plan replace',0
go
EXEC sp_configure 'additional network memory',10240
go
EXEC sp_configure 'allocate max shared memory',0
go
EXEC sp_configure 'allow backward scans',1
go
EXEC sp_configure 'allow nested triggers',1
go
EXEC sp_configure 'allow procedure grouping',1
go
EXEC sp_configure 'allow remote access',1
go
EXEC sp_configure 'allow resource limits',0
go
EXEC sp_configure 'allow sendmsg',0
go
EXEC sp_configure 'allow sql server async i/o',1
go
EXEC sp_configure 'allow updates to system tables',0
go
EXEC sp_configure 'audit queue size',100
go
EXEC sp_configure 'auditing',0
go
EXEC sp_configure 'average cap size',200
go
EXEC sp_configure 'caps per ccb',50
go
EXEC sp_configure 'check password for digit',0
go
EXEC sp_configure 'cis bulk insert array size',50
go
EXEC sp_configure 'cis bulk insert batch size',0
go
EXEC sp_configure 'cis connect timeout',0
go
EXEC sp_configure 'cis cursor rows',50
go
EXEC sp_configure 'cis packet size',512
go
EXEC sp_configure 'cis rpc handling',0
go
--EXEC sp_configure 'configuration file',0,'F:\sybase\sybase_cs.cfg'
--go
EXEC sp_configure 'cpu accounting flush interval',200
go
EXEC sp_configure 'cpu grace time',500
go
EXEC sp_configure 'curread change w/ open cursors',1
go
EXEC sp_configure 'current audit table',1
go
EXEC sp_configure 'deadlock checking period',500
go
EXEC sp_configure 'deadlock pipe active',1
go
EXEC sp_configure 'deadlock pipe max messages',1000
go
EXEC sp_configure 'deadlock retries',5
go
EXEC sp_configure 'default character set id',2
go
EXEC sp_configure 'default database size',8
go
EXEC sp_configure 'default exp_row_size percent',5
go
EXEC sp_configure 'default fill factor percent',0
go
EXEC sp_configure 'default language id',0
go
EXEC sp_configure 'default network packet size',512
go
EXEC sp_configure 'default sortorder id',48
go
EXEC sp_configure 'default unicode sortorder',0,'binary'
go
EXEC sp_configure 'disable character set conversions',0
go
EXEC sp_configure 'disable disk mirroring',1
go
EXEC sp_configure 'disk i/o structures',256
go
EXEC sp_configure 'dtm detach timeout period',0
go
EXEC sp_configure 'dtm lock timeout period',300
go
EXEC sp_configure 'dump on conditions',0
go
EXEC sp_configure 'dynamic allocation on demand',1
go
EXEC sp_configure 'enable cis',1
go
EXEC sp_configure 'enable DTM',0
go
EXEC sp_configure 'enable enterprise java beans',0
go
EXEC sp_configure 'enable file access',0
go
EXEC sp_configure 'enable full-text search',0
go
EXEC sp_configure 'enable HA',0
go
EXEC sp_configure 'enable housekeeper GC',1
go
EXEC sp_configure 'enable java',0
go
EXEC sp_configure 'enable job scheduler',0
go
EXEC sp_configure 'enable ldap user auth',0
go
EXEC sp_configure 'enable monitoring',1
go
EXEC sp_configure 'enable pam user auth',0
go
EXEC sp_configure 'enable real time messaging',0
go
EXEC sp_configure 'enable rep agent threads',0
go
EXEC sp_configure 'enable row level access',0
go
EXEC sp_configure 'enable snmp',0
go
EXEC sp_configure 'enable sort-merge join and JTC',0
go
EXEC sp_configure 'enable ssl',0
go
EXEC sp_configure 'enable surrogate processing',1
go
EXEC sp_configure 'enable unicode conversions',0
go
EXEC sp_configure 'enable unicode normalization',1
go
EXEC sp_configure 'enable webservices',0
go
EXEC sp_configure 'enable xact coordination',1
go
EXEC sp_configure 'enable xml',0
go
EXEC sp_configure 'errorlog pipe active',1
go
EXEC sp_configure 'errorlog pipe max messages',1000
go
EXEC sp_configure 'esp execution priority',8
go
EXEC sp_configure 'esp execution stacksize',34816
go
EXEC sp_configure 'esp unload dll',0
go
EXEC sp_configure 'event buffers per engine',100
go
EXEC sp_configure 'event log computer name',0,'LocalSystem'
go
EXEC sp_configure 'event logging',1
go
EXEC sp_configure 'executable codesize + overhead',60204
go
EXEC sp_configure 'extended cache size',0
go
EXEC sp_configure 'global async prefetch limit',10
go
EXEC sp_configure 'global cache partition number',1
go
EXEC sp_configure 'heap memory per user',4096
go
EXEC sp_configure 'histogram tuning factor',1
go
EXEC sp_configure 'housekeeper free write percent',1
go
EXEC sp_configure 'i/o accounting flush interval',1000
go
EXEC sp_configure 'i/o batch size',100
go
EXEC sp_configure 'i/o polling process count',10
go
EXEC sp_configure 'identity burning set factor',5000
go
EXEC sp_configure 'identity grab size',1
go
EXEC sp_configure 'job scheduler interval',1
go
EXEC sp_configure 'job scheduler tasks',32
go
EXEC sp_configure 'license information',25
go
EXEC sp_configure 'lock address spinlock ratio',100
go
EXEC sp_configure 'lock hashtable size',2048
go
EXEC sp_configure 'lock scheme',0,'allpages'
go
EXEC sp_configure 'lock shared memory',0
go
EXEC sp_configure 'lock spinlock ratio',85
go
EXEC sp_configure 'lock table spinlock ratio',20
go
EXEC sp_configure 'lock wait period',2147483647
go
EXEC sp_configure 'log audit logon failure',0
go
EXEC sp_configure 'log audit logon success',0
go
EXEC sp_configure 'max async i/os per engine',2147483647
go
EXEC sp_configure 'max async i/os per server',2147483647
go
EXEC sp_configure 'max cis remote connections',0
go
EXEC sp_configure 'max concurrently recovered db',0
go
EXEC sp_configure 'max memory',2097151
go
EXEC sp_configure 'max network packet size',6144
go
EXEC sp_configure 'max number network listeners',5
go
EXEC sp_configure 'max online engines',4
go
EXEC sp_configure 'max parallel degree',1
go
EXEC sp_configure 'max scan parallel degree',1
go
EXEC sp_configure 'max SQL text monitored',256
go
EXEC sp_configure 'maximum dump conditions',10
go
EXEC sp_configure 'maximum failed logins',0
go
EXEC sp_configure 'maximum job output',32768
go
EXEC sp_configure 'memory alignment boundary',8192
go
EXEC sp_configure 'memory per worker process',1024
go
EXEC sp_configure 'messaging memory',400
go
EXEC sp_configure 'minimum password length',6
go
EXEC sp_configure 'msg confidentiality reqd',0
go
EXEC sp_configure 'msg integrity reqd',0
go
EXEC sp_configure 'number of alarms',40
go
EXEC sp_configure 'number of aux scan descriptors',200
go
EXEC sp_configure 'number of ccbs',0
go
EXEC sp_configure 'number of checkpoint tasks',1
go
EXEC sp_configure 'number of devices',10
go
EXEC sp_configure 'number of dtx participants',500
go
EXEC sp_configure 'number of dump threads',1
go
EXEC sp_configure 'number of engines at startup',4
go
EXEC sp_configure 'number of histogram steps',20
go
EXEC sp_configure 'number of index trips',0
go
EXEC sp_configure 'number of java sockets',0
go
EXEC sp_configure 'number of large i/o buffers',6
go
EXEC sp_configure 'number of locks',100000
go
EXEC sp_configure 'number of mailboxes',30
go
EXEC sp_configure 'number of messages',64
go
EXEC sp_configure 'number of oam trips',0
go
EXEC sp_configure 'number of open databases',12
go
EXEC sp_configure 'number of open indexes',10000
go
EXEC sp_configure 'number of open objects',50000
go
EXEC sp_configure 'number of pre-allocated extents',2
go
EXEC sp_configure 'number of remote connections',20
go
EXEC sp_configure 'number of remote logins',20
go
EXEC sp_configure 'number of remote sites',10
go
EXEC sp_configure 'number of sort buffers',500
go
EXEC sp_configure 'number of user connections',500
go
EXEC sp_configure 'number of worker processes',0
go
EXEC sp_configure 'o/s file descriptors',100000
go
EXEC sp_configure 'object lockwait timing',1
go
EXEC sp_configure 'open index hash spinlock ratio',100
go
EXEC sp_configure 'open index spinlock ratio',100
go
EXEC sp_configure 'open object spinlock ratio',100
go
EXEC sp_configure 'page lock promotion HWM',200
go
EXEC sp_configure 'page lock promotion LWM',200
go
EXEC sp_configure 'page lock promotion PCT',100
go
EXEC sp_configure 'page utilization percent',95
go
EXEC sp_configure 'partition groups',1024
go
EXEC sp_configure 'partition spinlock ratio',10
go
EXEC sp_configure 'per object statistics active',1
go
EXEC sp_configure 'percent database for history',20
go
EXEC sp_configure 'percent database for output',30
go
EXEC sp_configure 'percent history free',30
go
EXEC sp_configure 'percent output free',50
go
EXEC sp_configure 'performance monitoring option',0
go
EXEC sp_configure 'permission cache entries',15
go
EXEC sp_configure 'plan text pipe active',1
go
EXEC sp_configure 'plan text pipe max messages',1000
go
EXEC sp_configure 'print deadlock information',0
go
EXEC sp_configure 'print recovery information',0
go
EXEC sp_configure 'procedure cache size',102400
go
EXEC sp_configure 'process wait events',1
go
EXEC sp_configure 'read committed with lock',0
go
EXEC sp_configure 'recovery interval in minutes',5
go
EXEC sp_configure 'remote server pre-read packets',3
go
EXEC sp_configure 'row lock promotion HWM',200
go
EXEC sp_configure 'row lock promotion LWM',200
go
EXEC sp_configure 'row lock promotion PCT',100
go
EXEC sp_configure 'runnable process search count',2000
go
EXEC sp_configure 'sampling percent',0
go
EXEC sp_configure 'secure default login',0,'guest'
go
EXEC sp_configure 'select on syscomments.text',1
go
EXEC sp_configure 'send doneinproc tokens',1
go
EXEC sp_configure 'shared memory starting address',0
go
EXEC sp_configure 'size of auto identity column',10
go
EXEC sp_configure 'size of global fixed heap',150
go
EXEC sp_configure 'size of process object heap',1500
go
EXEC sp_configure 'size of shared class heap',1536
go
EXEC sp_configure 'size of unilib cache',0
go
EXEC sp_configure 'SQL batch capture',1
go
EXEC sp_configure 'SQL Perfmon Integration',1
go
EXEC sp_configure 'sql server clock tick length',100000
go
EXEC sp_configure 'sql text pipe active',1
go
EXEC sp_configure 'sql text pipe max messages',1000
go
EXEC sp_configure 'stack guard size',16384
go
EXEC sp_configure 'stack size',41984
go
EXEC sp_configure 'start mail session',0
go
EXEC sp_configure 'statement cache size',0
go
EXEC sp_configure 'statement pipe active',1
go
EXEC sp_configure 'statement pipe max messages',1000
go
EXEC sp_configure 'statement statistics active',1
go
EXEC sp_configure 'strict dtm enforcement',0
go
EXEC sp_configure 'suspend audit when device full',1
go
EXEC sp_configure 'syb_sendmsg port number',0
go
EXEC sp_configure 'systemwide password expiration',0
go
EXEC sp_configure 'tape retention in days',0
go
EXEC sp_configure 'tcp no delay',1
go
EXEC sp_configure 'text prefetch size',16
go
EXEC sp_configure 'time slice',100
go
EXEC sp_configure 'total data cache size',968450
go
EXEC sp_configure 'total logical memory',719811
go
EXEC sp_configure 'total physical memory',719877
go
EXEC sp_configure 'txn to pss ratio',16
go
EXEC sp_configure 'unified login required',0
go
EXEC sp_configure 'upgrade version',12500
go
EXEC sp_configure 'use security services',0
go
EXEC sp_configure 'user log cache size',8192
go
EXEC sp_configure 'user log cache spinlock ratio',20
go
EXEC sp_configure 'wait event timing',1
go
EXEC sp_configure 'xact coordination interval',60
go
EXEC sp_configure 'xp_cmdshell context',1
go
