I have an SQL2k server running on a w2k advserver running a periodic merge
with an identical machine and i have noticed that the memory usage on the
machine that i can see is running very high - with 256 mb Ram SQL appears to
be using 120 mb. IS this right - the replication is not scheduled to run
for another 12 hours and there is no maintenance scheduled. Has anyone
experienced this or are we now into code red III sql worms etc...
Incidently before anyone suggests it we are patched and taped to the gills
having already been caught out by our friends the chinese hackers.
If anyone has any suggstions about how to manage the memory or even isolate
what exactly is causing the problem I like to hear it