Quite often, I see database administrators set SQL Server Max Server Memory thinking that only everything related to SQL Server uses this shared memory pool. This is a mistake. There are many things that rely on memory that are not part of SQL Server. Best practices state that you should leave memory allotted for the operating system.
source https://www.c-sharpcorner.com/article/careful-with-your-sql-server-max-memory-settings/
No comments:
Post a Comment