Post Configuration steps for MS SQL SERVER Part 1 | Min and Max Memory

Join this channel to get access to perks: https://www.youtube.com/channel/UC6PK1AEcqGp81GWpq_GNJpg/join Join the whats app Group for the scripts and assistance: https://chat.whatsapp.com/LBDdY1UA0Sn8VjarhMeV7j ======================== EXEC sys.sp_configure N'show advanced options', N'1' RECONFIGURE WITH OVERRIDE GO DECLARE @ServerMemory int = (SELECT (total_physical_memory_kb/1024) AS total_physical_memory_mb FROM sys.dm_os_sys_memory) DECLARE @setMemory int = (SELECT @ServerMemory*(.80)) DECLARE @setminMemory int = 2048 EXEC sys.sp_configure N'max server memory (MB)', @setMemory EXEC sys.sp_configure N'min server memory (MB)', @setminMemory GO RECONFIGURE WITH OVERRIDE GO EXEC sys.sp_configure N'show advanced options', N'0' RECONFIGURE WITH OVERRIDE GO PRINT 'Max Memory Changed Successfully'; PRINT 'Min Memory Changed Successfully'; =================================== You Can Also Download the scripts from below folder https://drive.google.com/drive/folders/1vzcHXjQWuPmIRlB-QHbh37z4Qs_CrzUT?usp=sharing We strongly believe there is always chance of betterment, so suggestions are most welcome. Happy learning, and best of luck in your professional journey! The journey of improvement is ongoing and never be an end. Thank you! MS SQL DBA Tech Support