Backtrack:  
 
by lunarg on August 19th 2024, at 11:08

You can set the Microsoft SQL Server memory limits via command-line using sqlcmd. This is useful if you do not have SSMS available.

Connect to the server using sqlcmd. If you are running locally with the default instance, this is as easy as running the following from the command prompt:

sqlcmd -S

Note that you will need to have sysadmin permissions to be able to make the changes.

Run the following commands to set the minimum and maximum memory limits:

EXEC sys.sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sys.sp_configure 'min server memory', 1024;
GO
EXEC sys.sp_configure 'max server memory', 4096;
GO
RECONFIGURE;
GO

In the example above, we set the minimum memory to 1 GB (1024 MB) and the maximum to 4 GB (4096 MB).

 
 
« November 2024»
SunMonTueWedThuFriSat
     12
3456789
10111213141516
17181920212223
24252627282930
 
Links
 
Quote
« Debating Windows vs. Linux vs. Mac is pointless: they all have their merits and flaws, and it ultimately comes to down to personal preference. »
Me