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

Virtual memory Expand / Collapse
Author
Message
Posted Tuesday, September 24, 2013 1:37 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 19, 2014 1:03 PM
Points: 298, Visits: 1,104
Is virtual memory measured in terms of the size of pagefile.sys file?
Post #1498023
Posted Tuesday, September 24, 2013 2:15 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:45 AM
Points: 39,878, Visits: 36,222
No.
Virtual address space is 2GB on 32 bit, many hundreds of TB on 64 bit. Commitable virtual memory is physical memory + page file size.

It's complex, there's a couple of videos I can find if you want on memory management in windows. What's the problem you're trying to solve?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1498035
Posted Tuesday, September 24, 2013 2:48 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 19, 2014 1:03 PM
Points: 298, Visits: 1,104
GilaMonster (9/24/2013)
No.
Virtual address space is 2GB on 32 bit, many hundreds of TB on 64 bit. Commitable virtual memory is physical memory + page file size.

It's complex, there's a couple of videos I can find if you want on memory management in windows. What's the problem you're trying to solve?


I'm just trying to understand the memory management in windows.
I'd really appreciate if you can guide me to those videos.
Post #1498041
Posted Tuesday, September 24, 2013 3:51 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:45 AM
Points: 39,878, Visits: 36,222
http://channel9.msdn.com/Events/Speakers/Mark-Russinovich The two Mysteries of Memory Management.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1498069
Posted Wednesday, September 25, 2013 9:37 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 19, 2014 1:03 PM
Points: 298, Visits: 1,104
GilaMonster (9/24/2013)
http://channel9.msdn.com/Events/Speakers/Mark-Russinovich The two Mysteries of Memory Management.


Super Useful. Thanks Gail.
Post #1498447
Posted Wednesday, September 25, 2013 9:46 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:45 AM
Points: 39,878, Visits: 36,222
Took me about 3 viewings to get to the point I kinda understood things. Windows memory management is not simple.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1498454
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse