sp_configureshowadvancedoptions,1
reconfigure
go
sp_configueaweenabled,1
reconfigure
go
--★★手动设置内存选项:★★★★★★★★★★★★★★★★★★
sp_configureshowadvancedoptions,1
go
reconfigure
go
sp_configureminservermemory--服务器最小内存
sp_configuremaxservermemory--服务器最年夜内存
sp_configureindexcreatememory--创立索引占用的内存
sp_configureminmemoryperquery--每次查询占用的最小内存
)returnsvarchar(20)
as
begin
declare@revarchar(20),@ireint--前往形态
declare@srvidint--界说服务器、数据库集id
declare@errint,@srcvarchar(255),@descvarchar(255)--毛病处置变量
EXECsp_configureshowadvancedoptions,1
RECONFIGURE
go
EXECsp_configurexp_cmdshell,1
RECONFIGURE
GO
selecta.name,a.database_id,a.create_date,b.physical_nameinto#a
fromsys.databasesaleftjoinsys.master_filesbon
a.database_id=b.database_idwherehas_dbaccess(a.name)1andb.type=1
usedb
go
select
a.index_id,---索引编号
b.name,---索引称号
avg_fragmentation_in_percent---索引的逻辑碎片
from
sys.dm_db_indx_physical_stats(db_id(),object_id(Ncreate.consume),null,null,null)asa
join
sys.indexesasb
on
a.object_id=b.object_id
and
a.index_id=b.index_id
go