Here is a script that can be used to limit the maximum memory available to Sql-Server
EXEC sys.sp_configure N'max server memory (MB)', N'8192' GO RECONFIGURE WITH OVERRIDE GO
Where 8192 is 8gb in the above example
Remember, if you want me to respond to your comment, then you need to use a Google/OpenID account to leave the comment.
No comments:
Post a Comment
Remember, if you want me to respond to your comment, then you need to use a Google/OpenID account to leave the comment.