SQL Server Performance

excessive memory usage by sql server 2k.

Discussion in 'Performance Tuning for Hardware Configurations' started by mrunalbhatt, Jun 29, 2007.

  1. mrunalbhatt New Member

    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?

  2. satya Moderator

Share This Page