How to increase memory for SQL without SQL management console



open command line and enter

sqlcmd -S ServerName -U sa -P PASSWORD FOR SQL SA USER –A
sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO
sp_configure ‘max server memory’, 4096; 1GB=1024
GO
RECONFIGURE;
GO


Microsoft Exchange SAN UCC SSL

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.