July 5, 2007 at 12:53 am
This question is in reference to Performance Counter of SQL Memory Manager:-
Target Memory
Total Memory
The counters that i see in Perfoman for Target & Total is from Physical RAM or Vitual Address Space(VDS). Any info on this is appreciated. thank you.
July 5, 2007 at 1:59 am
Those are from Physical Memory.
Total Server Memory (KB), tells you how much the mssqlserver service is currently using. The second counter, SQLServer: Memory Manager: Target Server Memory (KB) tells you how much memory SQL Server would like to have in order to operate efficiently. This is based on the number of buffers reserved by SQL Server when it is first started up.
If, over time, the SQLServer: Memory Manager: Total Server Memory (KB) counter is less than the SQLServer: Memory Manager: Target Server Memory (KB) counter, then this means that SQL Server has enough memory to run efficiently. On the other hand, if the SQLServer: Memory Manager: Total Server Memory (KB) counter is more or equal than the SQLServer: Memory Manager: Target Server Memory (KB) counter, this indicates that SQL Server may be under memory pressure and could use access to more physical memory.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply