This script collects a broad set of SQL Server instance and current-database diagnostic and configuration values and returns them as a two-column result set (ItemKey, ItemValue). The script builds a ...
max_server_memory_mb - (Optional) Maximum amount memory that SQL Server Memory Manager can allocate to the SQL Server process. Possible values are between 128 and 2147483647 Defaults to 2147483647.