on below example we are setting Limit to the 500MB
sp_configure 'show advanced options',1
go
reconfigure
go
sp_configure 'max server memory', 500
go
reconfigure
go
like this way you can set the limit server memory, but for precaution you can try this on local machine without running diretly on live server.
No comments:
Post a Comment