Fix Microsoft SQL Express Memory Issues

Fix Microsoft SQL Express Memory Issues

Fix Microsoft SQL Express Memory Issues

In this example, we have Microsoft SQL Server express. We know that express only can use 1GB RAM and One Processor. What can we do to fine-tune this scenario?

Our SQL Server only has 1GB of RAM in the first place, but our SQL Database is only 400MB, so how can we stop SQL Server from taking all the RAM un-necessarily?

login to SQL Server Management studio to get started

SQL Server 2008 Management Studio Connect to Server dialog using Windows Authentication

from here we need to take a look at our database server softwareObject Explorer right-click menu on the SQL2008R2 instance with Properties highlighted

go to the database properties

Server Properties Memory page with Maximum server memory set to 768 MB

under the memory tab, change the Maximum number of server memory (in MB) to the appropriate size. Note your maximum is 1GB in Express, and you would want to change that to a lower number if you have a small database.

That’s it!

Related guides: Backup SQL Server Express | Install SQL Server 2012 Express

Leave a Reply

Your email address will not be published. Required fields are marked *