Check for memory

• RaviShankar1234

  SSCommitted

  Points: 1647

  More actions

  August 24, 2010 at 10:39 pm

  #228271

  Hi All,

  Can any one tell me how check for memory that is being used by sql server 2008. is there a DMV or DBCC command to see how much memory presently sql server is being used?

  Thanks,

  Ravi

• Jorge Segarra

  SSCrazy

  Points: 2571

  More actions

  August 24, 2010 at 10:39 pm

  #1211443

  DBCC MEMORYSTATUS http://support.microsoft.com/kb/907877

  =============================================================
  /* Backups are worthless, Restores are priceless */

  Get your learn on at SQL University!
  Follow me on Twitter | Connect on LinkedIn
  My blog: http://sqlchicken.com
  My book: Pro Server 2008 Policy-Based Management