Getting values from taskmgr.exe programatically

• dave hants

  Default port

  Points: 1485

  More actions

  June 20, 2011 at 4:30 am

  #242408

  Hi,

  I am using SQL Server 2008 on Windows Server 2008. When I remote into the server I can run taskmgr.exe and view the cpu use and the total memory using the performance tab and it shows the information in very easy to read graphs.

  I would like to get a snapshot of these values sent to me each morning by email without loging into the server.

  I am getting the cpu values from sys.dm_os_ring_buffers and that works fine.

  But I can't seem to find any place that holds the total memory in use. I've tried record RING_BUFFER_SCHEDULER_MONITOR but the value this returns doesn't match up quite with what I see in the taskmgr graph. At the time of running the above, the graph was showing "memory / physical memory usage history = 2.23GB" but the RING_BUFFER_SCHEDULER_MONITOR output didn't show any 2.23GB values, anywhere in this output.

  I've looked at various dmv's ( eg. sys.dm_os_sys_memory ) but can't seem to tie up any values to match what I am seeing in taskmgr for memory use. Is there a view showing op system mem use?

  Any tips appreciated.

  Regards, Dave