Use master
go
sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO
sp_configure ‘max server memory’, 4096; —provide memory want to set
GO
RECONFIGURE;
GO
Use master
go
sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO
sp_configure ‘max server memory’, 4096; —provide memory want to set
GO
RECONFIGURE;
GO