Finding Memory usage of applications running on SQL Server 2005

• sqlMike-248643

  Grasshopper

  Points: 14

  More actions

  May 18, 2009 at 11:10 am

  #200563

  I am trying to find a way to monitor the memory usage of appications/stored procedures on SQL Server 2005. Any suggestions would be appreciated.

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  May 18, 2009 at 11:21 am

  #996516

  Hi Mike

  Look for DMVs "sys.dm_exec_sessions" and "sys.dm_exec_requests"

  Greets

  Flo