In the Help File for Total Memory, the information is incorrect.
See screenshot below with the highlighted incorrect information:
Setting the MAX memory to 0 in SQL Server 2016 will cause SQL Server to fail.
From Microsoft: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options the default maximum amount of memory is 2147483647 MB not 0, and the minimum memory amount allowable for max server memory is 128 MB.
STATUS:
Waiting for fix in a future release of Spotlight Enterprise
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center