Sql server Virtual Memory

• klineandking

  SSCrazy

  Points: 2570

  More actions

  November 17, 2009 at 3:07 pm

  #140038

  Hey people can someone tell me how to see the amount of memory sql server is using in sql server management studio, i want to know if there is a system stored procedure, a sys schema,a dmv or a dbcc command which allows to view the memory sql server uses compared to the installed memory i have on the machine

• Bru Medishetty

  SSC-Insane

  Points: 23606

  More actions

  November 17, 2009 at 5:17 pm

  #1080625

  From SSMS, run this

  SELECT * from sys.sysperfinfo where COUNTER_NAME LIKE '%TOTAL SERVER MEMORY%'

  Alternately, use Performance Monitor and look for Memory Manager Object.

  Check this link http://technet.microsoft.com/en-us/library/ms190924%28SQL.90%29.aspx

  ---

  Bru Medishetty

  Blog -- LearnSQLWithBru

  Join on Facebook Page Facebook.comLearnSQLWithBru

  Twitter -- BruMedishetty

• Paul White

  SSC Guru

  Points: 150467

  More actions

  November 17, 2009 at 5:19 pm

  #1080626

  http://support.microsoft.com/kb/271624

  http://blogs.msdn.com/psssql/archive/2009/05/15/how-it-works-dbcc-memorystatus-locked-pages-allocated-and-singlepageallocator-values.aspx

  http://blogs.solidq.com/EN/rdyess/Lists/Posts/Post.aspx?List=46f36841-4c69-4240-b060-e0712db6f3ba&ID=8

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi

• klineandking

  SSCrazy

  Points: 2570

  More actions

  November 17, 2009 at 5:31 pm

  #1080631

  THANKs i appreciate