Forum Discussion
SQL Server 2019 Express memory leak after databases list query
You're right. I don't know why SQL Express is using more RAM, above the limit.
I don't know what SQL Server does when it starts.
I open SSMS and on the Databases item in the tree and click Refresh or Expand and when the databases are visible in the tree, SQL starts some process in bacground and reserves RAM. When sql consumes ca. 10gb RAM approx. sqlsrv.exe is not stable. I can't connect to SQL Server or I have error that internal memory limit has problem.
This situation started a few days ago. No installing new ones
programs or updates. It is possible that Windwos 11 installed any update on its own.
I upgraded SQL Server Express from 2019 to 2022 and the situation is the same.
In my opinion after start SQL server process sqlsrv.exe shoult to have maximim 700 - 800 MB RAM consumed after refresh databases list.
What this process is doing ?
You can additional try to limit the max memory stting.
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-ver16