Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Units of Process\Working Set counter? Expand / Collapse
Author
Message
Posted Tuesday, January 5, 2010 3:27 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 8:53 AM
Points: 1,861, Visits: 3,599
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


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #842467
Posted Tuesday, January 12, 2010 5:14 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 18, 2014 5:31 AM
Points: 363, Visits: 1,317
You can see its description in the "performance monitor":
"Working Set is the current size, in bytes, of the Working Set of this process..."
Post #846038
Posted Tuesday, January 12, 2010 6:08 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 8:53 AM
Points: 1,861, Visits: 3,599
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!


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #846069
Posted Tuesday, January 12, 2010 6:55 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 18, 2014 5:31 AM
Points: 363, Visits: 1,317
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.
Post #846107
Posted Tuesday, January 12, 2010 7:13 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 8:53 AM
Points: 1,861, Visits: 3,599
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!


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #846134
Posted Monday, October 22, 2012 1:06 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, July 20, 2014 3:06 PM
Points: 19, Visits: 144
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
Post #1375684
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse