...
MSSQL Server is very aggressive about memory allocation and will consume as much as it is allowed to very quickly. The MSSQL RAM limit should be set to never let the total RAM consumption exceed 80% of the available physical RAM (or there will be a significant negative impact on performance).
...
| Note |
|---|
Always remember to either restart SQL or Restart the server after making this change to ensure a timely update of the config setting |
...
...
More information on server configuration can be found here.
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-ver15
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
| Page Properties | ||
|---|---|---|
| ||
|