Modifying the Memory Limit for a Microsoft SQL Server Instance

Note: This content is no longer updated. For the latest content, please go to the user guide for M-Files Online. For information on the supported product versions, refer to our lifecycle policy.

Do the following steps to adjust the memory usage of a Microsoft SQL Server instance:

  1. Open Microsoft SQL Server Management Studio.
  2. Log in to your server.
  3. In Object Explorer, right-click a server of your choice and select Properties from the context menu.
    Result:The Server Properties dialog is opened.
  4. Click the Memory node.
  5. Under Server memory options, enter the desired amounts in the Minimum server memory and Maximum server memory fields.
  6. Click OK to close the Server Properties dialog.