Hi all

I am turning to you today as my last resort.

Memory on sql2k just started going up since 27 Jan 02h00 and been increasing
ever since. It is now at the point where it is utilizing the max amount of
memory.
Memory in machine 1023BM
allocated to SQL 800MB

Check performed.
db logs - None
SP mem usage - 27MB
Buffer hit ratio - 99.9
all process mem for sql = 450MB (where is the other 350MB?...I
wonder)
Checked the logs for error messages in both OS and SQL.
Checked jobs that could have been performed during the above mentioned time
- NONE

If any body can steer me in the right direction, please do so!

I have no idea what is going on. All the checks that I usually perform
reveals the nasty tick that is causing bottlenecks, but this one that I've
got now.... just no idea I tell you.



Cheers
Paul
MS Sql Server LazyDBA home page