Script to configure SQL Server Maximum Memory
I’ve often got SQL Server running on my workstation, laptop or VPC and find that it just soaks up all my memory. This script sets the maximum limit:
USE [master]
GO
-- Set max server memory limit
EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
EXEC sp_configure 'max server memory (MB)', 484
RECONFIGURE WITH OVERRIDE
-- Check the setting
EXEC sp_configure 'max server memory (MB)'
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
