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

Опубликовано: 29 Июль 2023
на канале: MS SQL DBA Tech Support
1,275
25

Join this channel to get access to perks:
   / @mssqldbatechsupport  

Join the whats app Group for the scripts and assistance:
https://chat.whatsapp.com/LBDdY1UA0Sn...
========================
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/folder...
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


Смотрите видео Post Configuration steps for MS SQL SERVER Part 1 | Min and Max Memory онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь MS SQL DBA Tech Support 29 Июль 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,275 раз и оно понравилось 25 людям.