Saturday, September 26, 2009

sql:Limit SQL Server memory

on SQL you can Set memory available to a sql instance
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

Post a Comment