virtual file size

• sqlfriend

  SSC Guru

  Points: 52781

  More actions

  March 19, 2014 at 3:55 pm

  #305440

  We have some monitoring sofware. Sometimes I am confused about concepts about paging related.

  For example I am confused about virtual memory size with paging file size.

  Does virtual memory size include both RAM size and Page file size?

  The reason I ask this is from calling msinfo32 in command line.

  I thought the virtual memory size is the size of page file, but the screen shows

  the virtual memory = physcal memory + page files size.

  This is where I got confused.

  Thanks,

• Grant Fritchey

  SSC Guru

  Points: 398890

  More actions

  March 20, 2014 at 4:06 am

  #1698615

  Virtual memory is both, the page file and your physical memory. For more on it here's the books online.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  March 20, 2014 at 10:20 am

  #1698771

  True, that's due to MS terminology. The VMem you were referring to should be referred to as Virtual Address Space.

  Check these ..

  http://windows.microsoft.com/en-us/windows/what-is-virtual-memory#1TC=windows-7

  http://windows.microsoft.com/en-us/windows/change-virtual-memory-size#1TC=windows-7

  http://msdn.microsoft.com/en-us/library/windows/desktop/aa366914(v=vs.85).aspx

  --

  SQLBuddy