Perfmon Counter Total vs Target Server Memory

• VastSQL

  SSC-Dedicated

  Points: 36097

  More actions

  May 17, 2018 at 12:19 am

  #330989

  Hi Experts,

  We have a server running 3 instance of SQL Server and one of them is assigned with 6GB as minimum and 8GB as maximum memory ,when run the perfmon counter the Target Server memory is very high at 8 GB and Total Server memory at 4GB. Why this difference ?

• e4d4

  SSCertifiable

  Points: 5777

  More actions

  May 17, 2018 at 1:09 am

  #1990762

  Nice explanation with examples, in short Target = max memory setting in MSSQL I'm curious what this counter show when the max memory is left to default... must check on labo.
  https://blobeater.blog/2017/03/01/sql-server-target-vs-total-memory/