One of my production sqlserver is taking more memory usage
in win task manager ----> Process it is showing sqlservr.exe :1,337,400k
server is of 2gb RAM
when ever this issue comes we r restarting the server for time being its ok .
But every time restarting the production server is not the good criteria
all users are complaining the server is slow () it is taking too much time to insert data from front end application.
we are using
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on Windows NT 5.2 (Build 3790: Service Pack 2, v.4354)
can pls send the some valuble solution to fix this issue (w/o restarting the server).
Thanks in advance