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
sp_configure ‘max server memory’, 4096
reconfigure with override

  • 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

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *