SQL Server 7 default to dynamically manage the the memory setting by
itself. Its default setting for min server memory is 0, and the default
setting for max server memory is 2147483647.
But if you really doubt its functionality (Microsoft claims you
should not), you may manually configure the memory setting, but you should
be reminded that manual memory assignment causes those assigned memory not
available to other apps or even OS.
Moreover, the word slow is too abstract, what and where exactly do you
feel the SLOW? Query? Connection? App Response? Or......? Find out the
cause and you will find the cure. I believe that Microsoft always stresses
that SQL 7 memory mgt is reliable, I doubt it should be other reason for
> Hi All
> I Have a One Question
> I Installed SQL Server Standard Edition on My Server That 4GB Memory
> But It Was Used Only 1GB Memory
> Server Was Slow that I Feel
> How Amount of Real Memory Can Handle SQL Server 7?
> Did You Know It?
> Please Tell To Me
> Regard gray