Sometimes you need this so it easier to run other services on the same system: [WayBack] windows – How do I limit MS SQL Server memory usage? – Server Fault.
Thanks wfaulk.
From How to configure memory options using SQL Server Management Studio:
Use the two server memory options, min server memory and max server memory, to reconfigure the amount of memory (in megabytes) managed by the SQL Server Memory Manager for an instance of SQL Server.
- In Object Explorer, right-click a server and select Properties.
- Click the Memory node.
- Under Server Memory Options, enter the amount that you want for Minimum server memory and Maximum server memory.
You can also do it in T-SQL using the following commands (example):
exec sp_configure 'max server memory', 1024 reconfigure
Related:
- [WayBack] Server Memory Server Configuration Options | Microsoft Docs
- [WayBack] Suggested Max Memory Settings for SQL Server 2005/2008 – SQLServerCentral (still relevant because it explains about when you run other services)
–jeroen