这些项目的值在哪个表中可以查看?有没有一个表或者视图储存这些值?
affinity mask
awe enabled
cost threshold for parallelism
cursor threshold
fill factor (%)
index create memory (KB)
lightweight pooling
locks
max degree of parallelism
max server memory (MB)
max text repl size (B)
max worker threads
min memory per query (KB)
min server memory (MB)
nested triggers
network packet size (B)
open objects
priority boost
query governor cost limit
query wait (s)
recovery interval (m)
scan for startup procs
set working set size
user connections好像只能用这种方式设置是吗?
SP_CONFIGURE ['configuration name'], [configuration setting value]
GO
RECONFIGURE WITH OVERRIDE
GO
affinity mask
awe enabled
cost threshold for parallelism
cursor threshold
fill factor (%)
index create memory (KB)
lightweight pooling
locks
max degree of parallelism
max server memory (MB)
max text repl size (B)
max worker threads
min memory per query (KB)
min server memory (MB)
nested triggers
network packet size (B)
open objects
priority boost
query governor cost limit
query wait (s)
recovery interval (m)
scan for startup procs
set working set size
user connections好像只能用这种方式设置是吗?
SP_CONFIGURE ['configuration name'], [configuration setting value]
GO
RECONFIGURE WITH OVERRIDE
GO
--CREATE VIEW sys.configurations AS
SELECT p.id AS configuration_id,
p.name,
v.value,
convert(sql_variant, p.minval) AS minimum,
convert(sql_variant, p.maxval) AS maximum,
convert(sql_variant, p.value) AS value_in_use,
p.description,
sysconv(bit, p.status & 1) AS is_dynamic, -- x_eco_Dynamic
sysconv(bit, p.status & 2) AS is_advanced -- x_eco_Advanced
FROM OpenRowset(TABLE CFGPROP) p
LEFT JOIN master.sys.sysobjvalues v
ON v.valclass = 50 AND v.objid = p.id
AND v.subobjid = 0 AND v.valnum = 0 -- SVC_CONFIG
sp_helptext master.sys.configurations
------------------------*/
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '.'.这是怎么回事?为什么不行呢,2k5