December 13, 2009 at 6:58 pm
I have SQL Server 2005 x64 Standard Edition running on windows server 2003 x64 standard edition with SP2. The version details for SQL Server are below
Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
The SQL Server is running on a virtual machine with 4 GB RAM. I have seen in the task manager that SQL Server is using almost 3.5 GB of RAM. From the activity monitor, i checked no one is connected to server. I have read on few blogs which say that x64 system do caching.
My question is, is it normal thing on SQL Server 2005 x64 to use all the available RAM on the system even if its not being used? This much RAM usage makes the system slow if some other process or application runs.
What would be ideal server configuration by keeping in mind that i want to have the ability for SQL Server to use all the available RAM when required. On the other hand, when it is not doing anything, then SQL Server should release the memory.
December 13, 2009 at 7:57 pm
SQL Server will use all the RAM it can based on activity. However, once the activity slows, it does not release that RAM, instead maintaining it's cache for the next connection. It doesn't know if that will come in 10s or 10hours, so it maintains it.
You can set a max memory for SQL to use, but you cannot set it to release memory when activity dies down.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
December 13, 2009 at 8:04 pm
Even i thought on the same lines after doing my research but i was not confident. Thats why i asked Masters for their suggestion. Thanks Steve for your feedback.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply