Virtual Memory Usage

• thinknight

  SSCrazy

  Points: 2068

  More actions

  January 23, 2009 at 5:38 am

  #126940

  Hi,

  In which cases or in which conditions SQL Server has to use virtual memory?

  Is there any dynamic memory view to query virtual memory parameters?

  Waiting your responses.

  thinKnight

• Waseem Jaleel

  SSCommitted

  Points: 1706

  More actions

  January 24, 2009 at 7:48 pm

  #932315

  The following are the reasons for high Virtual memory usage:

  There are a large number of databases on the system (for example, more than 500).

  Most of the databases are updated (for example, the databases do not have a "read only" status).

  There are enough concurrently active user connections to use most of the 255 SQL Server worker threads.

  I am not sure of anything else other than the Task MAnager(which will only show total memory usage). WIll keep you posted if I get any..

• Venkat Manohar

  SSC Enthusiast

  Points: 193

  More actions

  January 6, 2014 at 3:10 pm

  #1677895

  For SQL Server 2005, is there any query or something to find out the Total Virtual memory & Used Virtual memory?

  For above SQL Server 2005, I know that we can use both "sys.dm_os_sys_info" or "sys.dm_os_sys_memory" DMVs but not sure in 2005.

  Any help? Please