Skip to content

Limiting MSSQL Memory Consumption

Prerequisites§

  • Start SQL Server Management Studio (SSMS) on the MSSQL host.

Process§

  1. In the SSMS, access the Object Explorer panel.

  2. Connect to the requires MSSQL server.

    How to...

    1. In the panel, from the Connect list, select Database Engine.
      Server connection settings appear.

    2. In the window that appears, in the Server name field, enter localhost\<server name>.

    3. From the Authentication list, select Windows Authentication.
    4. Click Connect.

  3. In the Object Explorer panel, right click <hostname>\<MSSQL instance name>, and then select Properties.
    MSSQL properties appears.

  4. In the left pane, select the Memory tab.

  5. On the tab, in the Maximum server memory field, enter the maximum RAM size that will be available to DBMS.
  6. In the Server Properties area, click OK.
  7. On the Object Explorer panel, right click <hostname>\<MSSQL instance name>, and from the action menu, select Restart.