February 9, 2007 at 1:29 am
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
February 9, 2007 at 1:55 am
Alex
That behaviour is typical of SQL Server. It grabs all the memory it can and only gives it back if another process requires it. If you find that there's contention for memory with other applications, you can set the max server memory to a lower number.
John
February 9, 2007 at 2:05 am
ok...i understand that....but until now this wasnt happening....and the server run very slow
February 9, 2007 at 2:57 am
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) ?
February 9, 2007 at 3:39 am
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply