Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2007
    Posts
    2

    Unanswered: why SQL Server 2000 service eating so much memory?

    Hi to all, i have a very important problem...pls help me

    I have a server with Windows 2003 Server (3GB RAM) and SQL SERVER 2000 running on it, my problem is that sqlserv.exe eat 2GB RAM even if on this server nothing happen....if i restart the service of SQL Server everything is ok eat just 30 MB RAM but after some minutes...after i made a simple select or a simple delete....simple things he arrive to 2GB RAM...this not happen until now(2 days ago)...the problem is that when he arrive to ~2GB RAM the statio run very slow and i receive the error "Time out expire"

    this problem happens and on my local station where i have Win XP PRO (1 GB RAM) SQL Server 2000....

    thx a lot

  2. #2
    Join Date
    Jan 2007
    Posts
    2
    other question is....on one server with WIN 2003 SERVER (SQL Server 2000) and 3GB RAM memory....the AWE enabled must be 0 or 1 (enabled or disabled) ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •