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?