December 15, 2002 at 1:52 pm
I am getting memory usage problem with SQL server 2000. Memory usage is increasing even though no application is accessing the SQL server. Once any application is accessing the database, memory usage is increasing. But when we close the application, memory usage still remains same. Logically it should decrease. Can any one please tell me what can be the problem for same.
Himashu
December 15, 2002 at 2:39 pm
Its not supposed to decrease. SQL will try to use all memory allocated to it for caching of data, query plans, etc.
Andy
December 15, 2002 at 8:39 pm
Thanks for your resposne.
But is there any solution to decrease the memory usage in these cases? We are getting .7 or .8 gb memory usage if there are more than 1 lakhs records in SQL database and an applicaton is reading top 250 records from Database and updating the status in database.We have 250 MB RAM on my machine.
December 16, 2002 at 4:03 am
Are you saying the server has 250MB? If is using .7-.8GB then how much is physical memory. Also if it wants to use that much then be carefull as you may suffer memory bottlenecks but open SQL Server properties in EM and you will a tab labeled "memory", there you can set the maximum memory. The thing is though SQL will try to use as much memory as it can get it hands on and unless another app causing the OS to reallocate memory from SQL there is no reason for it to give it up. This one of the major performance features of SQL, so that it can cache data and save round trips to the Hard Drive. However, the fact that you state 250MB (still not sure if server baed on your statement) and is going to swap file may be a major indicator that you need more memory for the server anyway, I suggest get a GB installed but some infor will still be swapped as deemed neccessary.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply