Adjust memory usage by using configuration options in SQL Server

Submitted by Jochus on Thu, 24/09/2015 - 21:19 | Posted in: Windows
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.
About text formats

Full HTML

  • 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].
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.