How To Configure The Maximum Memory Usage For SQL Database Server?

How to configure the maximum memory usage for SQL database server?

Issue: How to configure the maximum memory usage for SQL database server?

Root Cause: Orchestrator Upgrade is failing because of memory issues.

Resolution:

  • In SQL Server Management Studio, right click the server and open Properties
  • Go to Memory page, and set a value of Maximum server memory option.