Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » Units of Process\Working Set counter?
Add to briefcase

Units of Process\Working Set counter? Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Marios Philippopoulos
Posted Tuesday, January 05, 2010 3:27 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:10 AM
Points: 1,824, Visits: 3,477
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 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
dmoldovan
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: Tuesday, May 14, 2013 5:51 AM
Points: 360, Visits: 1,260
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
Marios Philippopoulos
Posted Tuesday, January 12, 2010 6:08 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:10 AM
Points: 1,824, Visits: 3,477
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 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
dmoldovan
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: Tuesday, May 14, 2013 5:51 AM
Points: 360, Visits: 1,260
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
Marios Philippopoulos
Posted Tuesday, January 12, 2010 7:13 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:10 AM
Points: 1,824, Visits: 3,477
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 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
saurabh.x.sinha
Posted Monday, October 22, 2012 1:06 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 17, 2013 7:28 AM
Points: 19, Visits: 81
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

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.