SQLSERVERサーバ構成
SQL code
--
AWE
sp_configure
'
show advanced options
'
,
1
reconfigure
go
sp_configure
'
awe enable
'
,
1
--
AWE , 4G
go
sp_configure
'
show advanced options
'
,
0
reconfigure
go
--
sp_configure
'
show advanced options
'
,
1
reconfigure
go
sp_configure
'
cursor threshold
'
--
, ,
go
sp_configure
'
show advanced options
'
,
0
reconfigure
go
/*
'show advanced options' 0 1。 RECONFIGURE 。 name minimum maximum config_value run_value ----------------------------------- ----------- ----------- ------------ ----------- cursor threshold -1 2147483647 -1 -1 'show advanced options' 1 0。 RECONFIGURE 。
*/
--
sp_configure
'
show advanced options
'
,
1
reconfigure
go
sp_configure
'
default full-text language
'
--
2052 ,
go
sp_configure
'
show advanced options
'
,
0
reconfigure
go
/*
name minimum maximum config_value run_value ----------------------------------- ----------- ----------- ------------ ----------- default full-text language 0 2147483647 2052 2052
*/
--
sp_configure
'
show advanced options
'
,
1
reconfigure
go
sp_configure
'
disallow results from triggers
'
,
1
--
1 on
go
sp_configure
'
disallow results from triggers
'
,
0
--
0 off
go
sp_configure
'
show advanced options
'
,
0
reconfigure
go
/*
'disallow results from triggers' 1 1。 RECONFIGURE 。 'disallow results from triggers' 1 0。 RECONFIGURE 。
*/
--
sp_configure
'
index create memory
'
,
4096
GO
--
sp_configure
'
show advanced options
'
,
1
reconfigure
go
sp_configure
'
locks
'
--
- ', '
go
sp_configure
'
show advanced options
'
,
0
reconfigure
go
/*
name minimum maximum config_value run_value ----------------------------------- ----------- ----------- ------------ ----------- locks 5000 2147483647 0 0
*/
--
SQL
sp_configure
'
show advanced options
'
,
1
reconfigure
go
sp_configure
'
max worker threads
'
--
', '
go
sp_configure
'
show advanced options
'
,
0
reconfigure
go
/*
name minimum maximum config_value run_value ----------------------------------- ----------- ----------- ------------ ----------- max worker threads 128 32767 0 0
*/
--
sp_configure
'
query wait
'
,
go
--
SQL SERVER
sp_configure
'
remote query timeout
'
,
go
--
xp_cmdshell
sp_configure
'
show advanced options
'
,
1
reconfigure
go
sp_configure
'
xp_cmdshell
'
,
1
reconfigure
go
sp_configure
'
show advanced options
'
,
0
reconfigure
go
--
SQL SERVER
sp_configure
'
show advanced options
'
,
1
reconfigure
go
sp_configure
'
remote access
'
,
1
--
1
reconfigure
go
sp_configure
'
remote access
'
,
0
--
0
reconfigure
go
sp_configure
'
show advanced options
'
,
0
reconfigure
go
--
-
--
, SQL SERVER
net start MSSQLSERVER
--
net pause MSSQLSERVER
--
net
continue
MSSQLSERVER
--
-
net stop MSSQLSERVER
--
--
select
*
from
sys.configurations
go
--
configuration_id
--
ID
name
--
value
--
minimum
--
maximum
--
value_in_use
--
description
--
is_dynamic
--
1 reconfiguration
is_anvanced
--
1 show advanced
--
sp_configure , ,
:
http://www.cnblogs.com/meslog/