— Step -1 Check Your Configuration Values at Server level
SP_CONFIGURE ‘show advanced options’,1
Reconfigure with Override
go
— Step -2 Check About “min server memory (MB)” & “max server memory (MB)” options Config_value
SP_CONFIGURE ‘min server memory (MB)’
SP_CONFIGURE ‘max server memory (MB)’
— Step -3 Now you can set your prefer amount of Memory as Min & Max as per your’s Server Actual RAM, If its pure DB Box, Its Preferd as SQL:OS is 80:20 ratio ( Its my opinion, not any Standard).
SP_CONFIGURE ‘min server memory (MB)’,1024
Reconfigure with Override
go
SP_CONFIGURE ‘max server memory (MB)’,80% of Your Total RAM
Reconfigure with Override
go