Karthick P.K on SQL Server

What is Target Server Memory (KB)?

Posted by Karthick P.K on May 27, 2012

What is Target Server Memory (KB)?


To  super simplify  in conventional memory model  SQL Server calculates something like target1 and target2 pages using below formula



Target1 = Current committed pages of SQL Server + ( Available Physical Memory – min (Total Physical Memory Pages / 20, Available Physical Memory Pages / 2))

ullAvailPageFile: The maximum amount of memory the current process can commit, in bytes. This value is equal to or smaller than the system-wide available commit value. To calculate the system-wide available commit value, call GetPerformanceInfo and subtract the value of CommitTotal from the value of CommitLimit.


If (Max Server Memory < ullAvailPageFile)


Target2= Max Server Memory




Target2=Total Physical Memory



Target Server Memory (KB) =Minimum (Target1,Target2)


So if AvailablePhysicalMemory is very high (or) when MaxServermemory is low then Target Server Memory (KB) would give you the MaxServerMemory  else value derived from above formula.





Karthick P.K

3 Responses to “What is Target Server Memory (KB)?”

  1. singh said


  2. […] What is Target Server Memory (KB)? […]

  3. Violet said

    Thhis is a great post

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: