Sql Server Mem Settings

preview_player
Показать описание
here is the code
USE master
EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE

/*when u run the above statement u are supposed to get a 1 which means success 0 (success) or 1 (failure)*/

USE master
EXEC sp_configure 'min server memory (MB)', 2000
RECONFIGURE WITH OVERRIDE

EXEC sp_configure 'max server memory (MB)',64000
RECONFIGURE WITH OVERRIDE
Рекомендации по теме
welcome to shbcf.ru