Set a fixed amount of memory in SQL Server (Using SQL Server Management Studio)

Min Server memory and max server memory are two server memory options in SQL Server to configure the amount of memory (in megabytes) in the buffer pool used by an instance. SQL Server can change its memory requirements dynamically by default. But you can configure it based on your system memory.

Follow the following steps to set fixed amount of memory in SQL Server.

    1. Right click on server and select Properties in Object Explorer.

1

    1. Click/Select Memory node like below screen.

2

  1. Under Server Memory Options, enter the amount that you want forMinimum server memory and Maximum server memory. Here I used 4500 MB on basis of my system capacity.

Default settings:
Min server memory = 0
Max server memory = 2147483647 MB

Technical Solution

JavaScript

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

JQuery

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

AngularJs

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

JavaScript

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

Question Bank – All at a glance

JavaScript

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

JQuery

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

AngularJs

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

JavaScript

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

Software Practices (All Articles) at a glance

JavaScript

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

JQuery

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

AngularJs

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

JavaScript

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

MS SQL Server (All Articles) at a glance

JavaScript

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

JQuery

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

AngularJs

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

JavaScript

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

Other articles at a glance

JavaScript

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

JQuery

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

AngularJs

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

JavaScript

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

HTML/CSS (All Articles) at a glance

JavaScript

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

JQuery

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

AngularJs

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

JavaScript

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

JQuery

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1

AngularJs

  1. Decorator Design Pattern with C#
  2. Object Oriented Design Principles with C# – Part – 1