Hi , every day, at the same time, the administrator still receives the following email:

------------------------------­------------------------------­------------------------------­-------------------
"A large amount of memory is committed to applications and processes. Consistently high memory usage can cause performance problems.

To determine which processes and applications are using the most memory, use Task Manager. Monitor the activity of these resources over a few days. If they continue to use a high level of memory and are less critical processes or services, try stopping and then restarting them.

You can disable this alert or change its threshold by using the Change Alert Notifications task in the Server Management Monitoring and Reporting taskpad."

------------------------------­------------------------------­------------------------------­-------------------

the task manager shows me that sqlservr.exe memory usage more than 600.000 KB and furthermore in the task manager exists more than one I try present sqlservr.exe process, is it normal?

I followed the Mariëtte advices (Forums > Smallbusiness Server 2003 > Server issues

> Subject: A large amount of memory...help me!)

I installed on my server:

1. Exchange Service Pack 1 and the patches 843539 and I configure the boot.ini:
1. Add the /3GB switch to the Boot.ini file on the server.
2. Set the /USERVA=3030 parameter in the Boot.ini file.
3. Configure the HeapDeCommitFreeBlockThreshold registry value in the following registry key
2. Isa Service Pack 2 and I configure the setting for caching memory from 50% to 10% (http://www.smallbizserver.net/Default.aspx?tabid=132)

The only installation I did not execute is that of the SQL SP4.

What do you advise me to do?

I read the article http://support.microsoft.com/?id=321363 but I did not understand what to do well…

The installation of SQL Service Pack 4 would the problem solve me?

TIA

Simona

Hi Mariëtte,

from the Task Manager of the server showing is not possible the PID of the process that is consuming a lot of Ram.

If from Command prompt I run the order “qprocess *” I am able to see the PID of the processes but not the memory usage by every single process.

Therefore summing up if I open the Task Manager I do not see the PID but I see this alone:

If from Command prompt I run the order “qprocess *” I see this alone:

How can I verify the PID of the process that is consuming a lot of Ram?

Did I help?

TIA

Simona