top of page

T-SQL query to check SQL Server min server memory(MB) and max server memory(MB)

Updated: Jan 13, 2022

As per best practice, you must set SQL Server min and max server memory(MB) as post-installation steps. SQL Server 2019 installation configures the default or recommended values as well.


How do we check the configured values for min server memory(MB) and max server memory(MB) in SQL Server?


Execute the following T-SQL statement to return the required value.


SELECT c.value, c.value_in_use
FROM sys.configurations c WHERE c.[name] = 'max server memory (MB)'
Go
SELECT c.value, c.value_in_use
FROM sys.configurations c WHERE c.[name] = 'min server memory (MB)'

As shown below, it returns the max server memory(MB) value as 2147483647 MB. It is the default value for the new SQL Server installation.


Similarly, the default configuration for min server memory(MB) is 0, i.e., dynamic value.


SQL Server min server memory(MB) and max server memory(MB)

I already set the min and max server memory configuration in my demo environment. Therefore, it returns the following values.

Non-default SQL Server min server memory(MB) and max server memory(MB)

Note: You can refer to the article Min and Max memory configurations in SQL Server Database instances for understanding the concept behind memory configurations.

3,202 views2 comments

2 Comments


Glen Maxwell
Glen Maxwell
2 minutes ago

Assignment necessitates logical thinking and extensive knowledge. As a result, connecting with our Assignment help is sometimes necessary. Our UAE assignment help specialists excel at completing tasks quickly. You don't have to wait for the ideal time to get your homework help. We have served thousands of students from around the world and have never received negative feedback. Do you have any doubts? We offer professional services and advice to assist you in leading a problem-free lifestyle. You should expect more from us than you realize.

Like

To tell you the truth, it was a very powerful article and if I was still in college, I would send you flowers for such an excellent work, because it really opens a lot of doors on the way to knowledge, but when I was in college, I found a solution and programming homework help was not long in coming, I am very grateful to those guys who help students not only with literature and theoretical knowledge, but also help with the practical part. Therefore, to everyone who faces difficulties in programming, always remember that everything can be solved and help can be found.

Like
bottom of page