Hi All,

http://technet.microsoft.com/en-us/library/ms178145(v=sql.90).aspx

I have red the above article regarding Dynamic Memory Management and now I just want to check whether this option is enabled in my environment or not.

Is this by default enabled in the server or else Please suggest on how to achieve this

Regards,

Kalyan

If you are looking for max and min memory configuration, you can use the below:

sp_configure --To know all configurations


sp_configure 'max server memory (MB)' -- max memory
sp_configure 'min server memory (MB)' -- min memory

Ref: 

http://msdn.microsoft.com/en-IN/library/ms188787.aspx

Hello Kalyan,

Yes, by Default dynamic Memory Management is enabled. If you open the Server property in SSMS => Memory you will see Min mem = 0 and max mem = 2 PB

What specific do you want to know if is enable, Are you asking about "AWE mechanism"? If so it is configure using the sp_configure.

-- showe and configure advance options:
EXECUTE sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO

-- Now we can check if awe enabled:
EXECUTE sp_configure 'awe enabled'
GO

-- and enable it if needed
sp_configure 'awe enabled', 1
RECONFIGURE
GO

Is this by default enabled in the server or else Please suggest on how to achieve this

Regards,

Kalyan