SQL Server Memory

• CC-597066

  SSCommitted

  Points: 1637

  More actions

  July 4, 2017 at 6:51 pm

  #1949387

  "Available MBytes
  ....
  This counter cannot be queried through T-SQL; it has to be observed through Perfmon only."

  Can't you use sys.dm_os_sys_memory to pick that up?

  SELECT available_physical_memory_kb FROM sys.dm_os_sys_memory

• Robert Sterbal

  SSChampion

  Points: 11064

  More actions

  July 5, 2017 at 11:49 am

  #1949546

  Can I repost the performance metrics you discuss to my wiki?

  • Page Life Expectancy
  • Available Bytes
  • Buffer Cache Hit Ratio
  • Target & Total Server Memory
  • Memory Grants Pending
  • Pages/sec (Hard Page Faults)
  • Batch Requests/sec & Compilations/sec

  Thanks!

  412-977-3526 call/text