SQL Server Memory Usage

• Senthil Kumar P S

  Old Hand

  Points: 342

  More actions

  July 9, 2004 at 4:09 am

  #162188

  How do i get the total memory used by sql server instance at any given point of time?

  I want the total memory used currently instead of total allocated memory.

   

  Thanx in anticipation

  Senthil

   

• 8adger

  Right there with Babe

  Points: 768

  More actions

  July 9, 2004 at 5:54 am

  #514045

  Senthil,

  The best way I have found for this is using the following counter in perfmon:

  Process\PrivateBytes\SqlServr

  Then reset the scale to 0.000001

  Jamie