Refresh Memory Usage History in Taskman  
Author Message
glasgowd





PostPosted: Thu Dec 04 04:07:47 CST 2003 Top

SQL Server >> Refresh Memory Usage History in Taskman

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......

--
Regard,
Kzeto ng

SQL Server173  
 
 
Tibor





PostPosted: Thu Dec 04 04:07:47 CST 2003 Top

SQL Server >> Refresh Memory Usage History in Taskman 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

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver



> 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......
>
> --
> Regard,
> Kzeto ng
>
>
>


 
 
Willy





PostPosted: Thu Dec 04 13:17:39 CST 2003 Top

SQL Server >> Refresh Memory Usage History in Taskman 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.



> 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......
>
> --
> Regard,
> Kzeto ng
>
>
>