Total memory allocation and total memory consumption for SQL Server

• beejug1983

  SSCertifiable

  Points: 6491

  More actions

  July 16, 2013 at 3:13 am

  #280526

  Hi all,

  I have to find out the total memory allocated to SQL Server and how much memory SQL is actually using on both SQL Server 2005 and SQL Server 2008.

  Thanks in advance.

• dbafromthecold@gmail.com

  SSChampion

  Points: 10160

  More actions

  July 16, 2013 at 6:17 am

  #1632832

  Hi, use the Target Server Memory and Total Server Memory performance counters.

  Andrew