filmov
tv
Sql Server Mem Settings

Показать описание
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
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