Refresh Memory Usage History in Taskman

[Kzeto ng]

Hi,
After some time, my server Memory Usage History run up to 80%-90% even the
server does not have any connection in it.
This is server running only MS SQL 2000 + IIS in Win2K Server.

I was wondering that, by using the Win / WMI command to refresh / reset
this Memory Usage History.

Does anyone try this before or any ideal from you all?

Thank you......

 

[Tibor Karaszi]

Have a look at

INF: SQL Server Memory Usage
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321363

http://www.mssqlserver.com/faq/troubleshooting-memoryleak.asp

 

[Willy Denoyette [MVP]]

How much memory do you have, how much is assigned to SQL (see SQL
configuration parameters)?
And how much is the threshold set for IIS (check your machine.config file)?

Willy.