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]

Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged'
and 'confidential' and intended for use only by the individual or entity to which it is
addressed. You are notified that any use, copying or dissemination of the information
contained in the E-MAIL in any manner whatsoever is strictly prohibited.

****************************************************************************************



MS Sql Server LazyDBA home page