How is the "Adjust memory quotas for a process" user right assignment used in SQL Server 2019?
0
votes
1
answer
1953
views
I am looking at the Configure Windows Service Accounts and Permissions doc (https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions?view=sql-server-ver15) for SQL Server 2019 and it states that the SQL Service Account needs to have the **Adjust memory quotas for a process permission.**
Can anyone confirm why this is required and what it's function is within the SQL Engine. In my Dev environment, I do not have it enabled and all seems to be functioning correctly.
Asked by zapcon
(73 rep)
Sep 30, 2020, 04:16 PM
Last activity: Oct 1, 2020, 07:37 AM
Last activity: Oct 1, 2020, 07:37 AM