Check Available Server Physical Memory

• QQ-485619

  Ten Centuries

  Points: 1195

  More actions

  February 23, 2011 at 6:36 pm

  #157461

  Is there any way I could script to check the available physical memory for the server running sql 2005.

  Thanks,

• crazy4sql

  SSCoach

  Points: 19590

  More actions

  February 23, 2011 at 10:27 pm

  #1290733

  select * from sys.dm_os_sys_memory

  ----------
  Ashish

• nekonecny

  Right there with Babe

  Points: 720

  More actions

  February 25, 2011 at 3:34 am

  #1291434

  SQL Server 2005

  select physical_memory_in_bytes,virtual_memory_in_bytes from sys.dm_os_sys_info