SQL Server Performance Forum – Threads Archive
excessive memory usage by sql server 2k.
We are running Transaction Generator Test using SQL Serv 2K.50 users placing 5 request per sec per user. SQL server receiving approx. 500 insert request per sec. with row data size of approx. 1 KB. Our observation is Sql Server is consuming 1GB RAM withing 1 hour.
Thread Count = 77 OS : Win 2003 SP1 and security patches
Hardware : DELL POWEREDGE 2850 with Single Xeon cpu (HT enalbed) with 2GB memory.
SqlServer : 2000 with SP4 CAN ANYBODY suggests that why so much RAM consumption is happening?
any configuration on SQL Server side is require to do?
SQL will consume as much as memory available but will release whenever Windows requires it.
Refer to this KBAhttp://support.microsoft.com/kb/321363
quote:
When you start SQL Server, SQL Server memory usage may continue to steadily increase and not decrease, even when activity on the server is low. Additionally, the Task Manager and Performance Monitor may show that the physical memory available on the computer is steadily decreasing until the available memory is between 4 to 10 MB.
When you start SQL Server, SQL Server memory usage may continue to steadily increase and not decrease, even when activity on the server is low. Additionally, the Task Manager and Performance Monitor may show that the physical memory available on the computer is steadily decreasing until the available memory is between 4 to 10 MB.
http://www.sql-server-performance.com/sg_sql_server_performance_article.asp fyi.
I don’t see this as a problem and as long as the performance is good you need not worry.
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>