Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
california6
Starting Member
38 Posts |
 Posted - 2009-04-13 : 14:42:38
|
| I have a SQL 2005 production box running with 32 GB of memory. I have configured 28 GB for SQL Server: After a while, i have a user load of 600 connections on my server and here are the stats what i see:Working Set: 200 MBTotal Server memory: 28 GBTarget server memory: 28 GBI would like to know, if my box is under memory pressure. With the above stats, i assume SQL Server is consuming 28 GB of memory (According to Total Server memory) But why do i see Working set consuming 200 MB only? Is there any difference in my understanding?any help on this would be greatly apprecaited.Many thanks,CaliCali |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-04-13 : 14:53:10
|
| Is it 64 bit or 32 bit? Also have you enabled 'lock pages in memory' if 64-bit? |
 |
|
|
california6
Starting Member
38 Posts |
Posted - 2009-04-13 : 15:52:09
|
| Sorry forget to mentioned. But yes its a 64-bit server and yes lock memory in pages is granted to the sql account. now?Cali |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-04-13 : 15:54:38
|
| Then read this:http://blogs.technet.com/askperf/archive/2007/05/18/sql-and-the-working-set.aspx |
|
|
|
california6
Starting Member
38 Posts |
Posted - 2009-04-13 : 18:24:33
|
| Thanks for the URL: Gone through it and dont see, it is related to my issue. My concern was - total server memory is what sql server is consuming at that point in time. right? if yes, then why is working set and target size different? I believe, if total server memory is equal or greater to your assigned physical memory AND equal or greater to target server memory - then there is memory pressure.Cali |
|
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-04-16 : 05:33:44
|
quote:
Originally posted by california6
I have a SQL 2005 production box running with 32 GB of memory. I have configured 28 GB for SQL Server: After a while, i have a user load of 600 connections on my server and here are the stats what i see:Working Set: 200 MBTotal Server memory: 28 GBTarget server memory: 28 GBI would like to know, if my box is under memory pressure. With the above stats, i assume SQL Server is consuming 28 GB of memory (According to Total Server memory) But why do i see Working set consuming 200 MB only? Is there any difference in my understanding?any help on this would be greatly apprecaited.Many thanks,Cali
as per my understanding,The working set of a program is a collection of those pages in its virtual address space that have been recently referencedthus 200 MB is the size of the pages in the working set, and these pages are consuming the total server memory of 28 GBRegards,Ahmad Osama |
|
|
|
|
|
|
|
|
Memory question