Tag Archives: maximum

Limit SQL Server maximum memory SQL instance

  • Start SQL Server Management Studio
  • Connect to you SQL server instance
  • Start a “New Query”
  • And then put this into you SQLQuery1.sql window

sp_configure ‘show advanced options’,1
reconfigure with override
go
sp_configure ‘max server memory’, 4096
reconfigure with override
go

  • Then push the execute buttom, this will limit you SQL instance to 4096MB or 4GB. Please beware of, if you have multiple instance each instance you wan’t to limit