asked on

Process(_Total)\Working Set

On a Dedicated SQL Server, I am observing the following counter value over a week's time:

Process(_Total)\Working Set

Min 1204593651
Average 1299979594
Max 1687249807

This is 1.12GB, 1.21GB, 1.57GB respectively.

The Server has 8GB Ram, and 6GB max set to SQL; 0 as min.

What does these numbers mean?

thanks

ASKER CERTIFIED SOLUTION

sameer2010

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

LMiller7

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

anushahanna

ASKER

So, technically, if Working set is less than available mem, page fault would never occur?

So the average of 1.21Gb from above, is for all the processes that are running, not just SQL, right?

Would this be the sum of 'Mem Usage' column in Task Manager->Processes?

Thanks

SOLUTION

LMiller7

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

anushahanna

ASKER

LMiller7
Thanks for the helpful info.

Process(_Total)\Working Set is for Windows. See attached..
WorkingSet.bmp

anushahanna

ASKER

I did a quick run on just the main numbers. I am getting an average of

684MB AvailableRAM
43MB Pool Nonpaged
51MB Pool paged Resident
127MB System Cache Resident
0 System Code Resident
3MB System Driver Resident
1175MB Total Private Mem
8025MB Total Virtual Mem
1266 Total Working Set

Do you think maybe I should ignore the Process(_Total)\Working Set Counter, and come up with a formula with the above numbers?

thanks

sameer2010

Do you need this for calculating if your hardware is sufficient or processes are efficient?

anushahanna

ASKER

sameer2010
it is more to confirm if memory is doing ok, and if more is needed, to handle the processes.

anushahanna

ASKER

experts, can you help me figure working set from system counters, please:

684MB AvailableRAM
43MB Pool Nonpaged
51MB Pool paged Resident
127MB System Cache Resident
0 System Code Resident
3MB System Driver Resident
1175MB Total Private Mem
8025MB Total Virtual Mem

thanks