When the SQL Server starts, it begins by computing the upper size of the buffer pool, which is the maximum size to which the Server allows the buffer pool to grow. The lower value between the maximal buffer pool size and the amount of physical RAM on the disk is the total amount of memory currently allocated to SQL Server.
If the dynamic memory management mechanism is properly tuned, SQL Server can automatically tune its memory allocations based on the load it is processing and the demands of other Windows processes on the Server.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz