Neeraja

as Chris said right click on your instance in Enterprise manager , select
the Memory tab and change the maximum (MB) to what you would like it to be
and restart your instance

happy xmas
Richard Ridge




-----Original Message-----
From: Neeraja Rao [mailto:neeraja.[Email Address Removed] Tuesday, 24 December 2002 4:39 PM
To: LazyDBA.com Discussion
Subject: RE: Memory usage Urgent


Chris,

Can you be more clear on this. I am not able to locate what you are talking
about.

Regards
Neeraja

-----Original Message-----
From: Chris Kempster [mailto:[Email Address Removed] Monday, December 23, 2002 7:38 PM
To: LazyDBA.com Discussion
Subject: RE: Memory usage Urgent


Hi

Via EM, right click properties of your instance, click on memory table,
reduce by around 10 to 20% of total RAM (or whatever is appropriate). Dont
use working set. Re-start instance if the memory is not reduced immediatly
or try RECONFIGURE command in query analyser to attempt to force it.

Cheers

Ck

-----Original Message-----
From: Adil Basha [mailto:[Email Address Removed] Monday, 23 December 2002 9:49 PM
To: LazyDBA.com Discussion
Subject: Memory usage Urgent


Hi all
Greetings.
sql server2000 on windows 2000
My System is going very slow when i see in Windows
Task Manager. Sql server is using 76,300k Mem usage.
is there any way to reduce the Mem Usage.

Its urgent pls help

TIA
Adil

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page