Just installed Sql 2000 on Win 2k server std and Sql is
slowly but surely taking over all Memory on the system. I
have an Ibm e server with dual 1gig processor and 1 gig
memory. As we speak Sql is taking up almost 700 megs with
a max of 10 users using it. Is this normal, if not is
there something I can do to control it's memory usage?

tks Giacomo

Report this post to a moderator

It is normal. For more info:
http://support.microsoft.com/defaul...b;en-us;Q321363

--
HTH,
Vyas, MVP (SQL Server)
SQL Server FAQ, articles, code samples, interview questions and more @
http://vyaskn.tripod.com/




"Giacomo D'Agostino" <gdagostino@samuel.com> wrote in message
news:d64101c258f7$fcd50320$36e
f2ecf@tkmsftngxa12...
Just installed Sql 2000 on Win 2k server std and Sql is
slowly but surely taking over all Memory on the system. I
have an Ibm e server with dual 1gig processor and 1 gig
memory. As we speak Sql is taking up almost 700 megs with
a max of 10 users using it. Is this normal, if not is
there something I can do to control it's memory usage?

tks Giacomo

Report this post to a moderator