March 1, 2006 at 7:32 am
What can cause SQL Server to use alot of memory? I noticed on my server it is burning 1.7GB of memory right now, and it is not doing anything. I don't really do anything active with it except through some services that run at night. Right now there should be nothing active going on and it still is consuming all thouse resources.
March 1, 2006 at 12:16 pm
Sql server is greedy on memory but releases it when other applications need it.
Usually it starts with a "low" memory usage because it hasn't stored execution plans etc in cache. As commands pass by, sql server will store more and more reusable items in memory,acquiring free memory. If there is no memory "pressure", sql server will keep the acquired memory allocated.
When a competitor comes in, sql server and the competitor will possible struggle for the available resources (memory,...). If sql server doesn't need some of its occupied memory it will "release" this.
To limit the struggling, sql server has options like max server value, reserve physical memory.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply