Adjust memory usage by using configuration options in SQL Server

Submitted by Jochus on Thu, 24/09/2015 - 21:19 | Posted in: Windows

  • Open SQL Server Management Studio
  • Right click database server and choose Properties
  • Choose tab: Memory
  • By default, the value is set to 2147483647, which is the integer's max value. Adjust the Maximum/minimum server memory (in MB) to any number you would like

Add new comment

The content of this field is kept private and will not be shown publicly.


  • Lines and paragraphs break automatically.
  • You can caption images (data-caption="Text"), but also videos, blockquotes, and so on.
  • Web page addresses and email addresses turn into links automatically.
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <bash>, <cpp>, <css>, <html5>, <java>, <javascript>, <php>, <sql>, <xml>. The supported tag styles are: <foo>, [foo].
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.