April 20, 2004 at 6:52 pm
Hi,
I am working on a project that uses a MSDE 1.0 database. After performing a large number of transactions, MSDE appears to be using all of my system's memory and wil not release it until a restart. Is there any way of forcing MSDE to release this memory?
April 23, 2004 at 4:57 am
Use the same process as you would on a normal SQL Server database.
Connect to the MSDE instance in Enterprise Manager, right-click and select Properties, then set the required memory on the Memory tab.
Alternatively, run sp_configure 'max server memory' in Query Analyser, OSQL, etc.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply