SQLSRVR MEMORY USAGE

The program sqlsrvr.exe is using a vast amount of the memory on my server. I
am not sure what this is since I dont have SQL standalone databases (ie we
run QB Enterprise which uses its own variation of SQL which is QBDBMNGR.exe)
In any event I found some articles online that say this memory consumption
by sqlsrvr continue to grow until it uses all memory on the server up, at it
also says you can place limits, my question is, HOW do you place the limits.
The KB article: http://www.support.microsoft.com/?id=321363
does not say how to?
Thanks in advance.

Kevin
Thu Jan 05 15:07:10 CST 2006

http://msmvps.com/blogs/bradley/archive/2005/02/04/34984.aspx

--
Kevin Weilbacher [SBS-MVP]
"The days pass by so quickly now, the nights are seldom long"



"DMJR" <DMJR@discussions.microsoft.com> wrote in message
news:902A73C5-8865-4F66-9EA8-B1C9D4A9A892@microsoft.com...
> The program sqlsrvr.exe is using a vast amount of the memory on my server.
> I
> am not sure what this is since I dont have SQL standalone databases (ie we
> run QB Enterprise which uses its own variation of SQL which is
> QBDBMNGR.exe)
> In any event I found some articles online that say this memory consumption
> by sqlsrvr continue to grow until it uses all memory on the server up, at
> it
> also says you can place limits, my question is, HOW do you place the
> limits.
> The KB article: http://www.support.microsoft.com/?id=321363
> does not say how to?
> Thanks in advance.