CREATE proc [dbo].reclaimmemory --强制释放内存 asbegin DBCC FREEPROCCACHE DBCC FREESESSIONCACHE DBCC FREESYSTEMCACHE('All') DBCC DROPCLEANBUFFERS exec sp_configure 'max server memory', 256 EXEC ('RECONFIGURE' )WAITFOR DELAY '00:00:05'EXEC sp_configure 'max server memory', 2147483647 EXEC ('RECONFIGURE' )GO end
CREATE proc [dbo].reclaimmemory --强制释放内存
as
begin
DBCC FREEPROCCACHE
DBCC FREESESSIONCACHE
DBCC FREESYSTEMCACHE('All')
DBCC DROPCLEANBUFFERS
exec sp_configure 'max server memory', 256
EXEC ('RECONFIGURE' )
WAITFOR DELAY '00:00:05'
EXEC sp_configure 'max server memory', 2147483647
EXEC ('RECONFIGURE' )
GO
end
as
begin
DBCC FREEPROCCACHE
DBCC FREESESSIONCACHE
DBCC FREESYSTEMCACHE('All')
DBCC DROPCLEANBUFFERS
exec sp_configure 'max server memory', 256
EXEC ('RECONFIGURE' )
WAITFOR DELAY '00:00:05'
EXEC sp_configure 'max server memory', 2147483647
EXEC ('RECONFIGURE' )
GO
end
----------------------------------------------------------------------------------------------------------------------------------------------例子
CREATE PROCEDURE ClearMemory
AS
BEGIN
--清除所有缓存
DBCC FREEPROCCACHE
DBCC FREESESSIONCACHE
DBCC FREESYSTEMCACHE('All')
DBCC DROPCLEANBUFFERS
--打开高级配置
exec sp_configure 'show advanced options', 1
--设置最大内存值,清除现有缓存空间
exec sp_configure 'max server memory', 2048
EXEC ('RECONFIGURE')
--设置等待时间
WAITFOR DELAY '00:00:02'
--重新设置最大内存值
EXEC sp_configure 'max server memory', 10240
EXEC ('RECONFIGURE')
--关闭高级配置
exec sp_configure 'show advanced options',0
END
GO
AS
BEGIN
--清除所有缓存
DBCC FREEPROCCACHE
DBCC FREESESSIONCACHE
DBCC FREESYSTEMCACHE('All')
DBCC DROPCLEANBUFFERS
--打开高级配置
exec sp_configure 'show advanced options', 1
--设置最大内存值,清除现有缓存空间
exec sp_configure 'max server memory', 2048
EXEC ('RECONFIGURE')
--设置等待时间
WAITFOR DELAY '00:00:02'
--重新设置最大内存值
EXEC sp_configure 'max server memory', 10240
EXEC ('RECONFIGURE')
--关闭高级配置
exec sp_configure 'show advanced options',0
END
GO