Units of Process\Working Set counter?

Question

Post reply

Units of Process\Working Set counter?

Marios Philippopoulos

SSC Guru

Points: 57190
More actions
January 5, 2010 at 3:27 pm

#215195

I'm collecting the Process(sqlserv)\Working Set counter on one of my servers and getting values like this:
27418284032
What units is this in? Bytes? Pages?
I need to compare these values with the min/max memory settings on my SQL instance.
Monitoring Memory Usage
http://technet.microsoft.com/en-us/library/ms176018.aspx
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

dmoldovan SSCertifiable Points: 6334 More actions · Answer 1

You can see its description in the "performance monitor":

"Working Set is the current size, in bytes, of the Working Set of this process..."

Marios Philippopoulos SSC Guru Points: 57190 More actions · Answer 2

dmoldovan (1/12/2010)
You can see its description in the "performance monitor":
"Working Set is the current size, in bytes, of the Working Set of this process..."

Thanks, but where do you see that in the link I mentioned?

I took the definition you provided and did a google search; found this link with the exact quote:

http://stackoverflow.com/questions/1984186/what-is-private-bytes-virtual-bytes-working-set/1986486

I had a feeling the units was in bytes but needed a confirmation.

Thanks for the help!

__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

dmoldovan SSCertifiable Points: 6334 More actions · Answer 3

You're welcome.

The description I talked about is not taken from the MSDN link you mentioned. By the way, in my opinion the MSDN documentation is weaker and weaker...

This is a part of the counter description that you can see when adding the counter to a "performance log" in the perfmon tool.

Marios Philippopoulos SSC Guru Points: 57190 More actions · Answer 4

dmoldovan (1/12/2010)
You're welcome.
The description I talked about is not taken from the MSDN link you mentioned. By the way, in my opinion the MSDN documentation is weaker and weaker...
This is a part of the counter description that you can see when adding the counter to a "performance log" in the perfmon tool.

Oh I see, I should have thought of that, sometimes it's the simplest things that get you... 🙂

Thanks again!

__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

saurabh.x.sinha Ten Centuries Points: 1125 More actions · Answer 5

Hi

I am also first time trying to use these for analysing issue for alert in error log (A significant part of sql server process memory has been paged out).

What exactly you are trying to do. If you can share your analysis or some more findings , this will be gr8