Skip to main content

T-SQL to set Max memory in MSSQL

 To set max memory for Microsoft SQL server, use the below Transact SQL.

USE master
EXEC sp_configure ''show advanced options'', 1
RECONFIGURE WITH OVERRIDE
GO
--To set a maximum memory limit, type the following, pressing Enter after each line:
USE master
EXEC sp_configure ''max server memory (MB)'', <MaxServerMemory>
RECONFIGURE WITH OVERRIDE
GO
--MaxServerMemory is the value of the physical memory in megabytes (MB) that you want to allocate.
--To hide the maximum memory setting, type the following, pressing Enter after each line:
USE master
EXEC sp_configure ''show advanced options'', 0
RECONFIGURE WITH OVERRIDE
GO
exit
Labels:

Comments

Post a Comment

Popular posts from this blog

Table and its count

Table and its count To view all tables and its count by executing command and immediately, use below commands - MSSQL SELECT      sc. name   + '.' + ta. name   TableName,  SUM (pa. rows ) RowCnt FROM      sys.tables ta INNER   JOIN   sys.partitions pa      ON   pa.OBJECT_ID = ta.OBJECT_ID INNER   JOIN   sys.schemas sc      ON   ta.schema_id = sc.schema_id WHERE   ta.is_ms_shipped = 0  AND   pa.index_id  IN   (1,0) GROUP   BY   sc. name ,ta. name ORDER   BY   SUM (pa. rows )  DESC  
Post a Comment
Read more