I have a server that is being repurposed into a SQL Server. It came with more physical memory than the 32GB that can be seen by my OS (Windows Server 2008 R2).
Management would like me to configure the Maximum server memory used by SQL (SQL Server 2008 R2 Service Pack 3) to be higher than what is seen by the OS. I can change it in the properties of SQL Server via SQL Server Management Studio. Will SQL Server be able to utilize the additional RAM? Or will it exhaust all memory made available to the OS?