How can I obtain actual memory used by Sql server?
My server has
128 GB of RAM,
Windows 2003 R2 (x64),
Sql server 2008 R2 (Data Center x64),
Min & max server memory =100,000 & 125,000.
Target server memory(kb) and Total Server Memory shows 124,870,144 (windows task manager shows the same) but Orion Network Performance Monitor shows server uses about 2Gb of ram !!! what happens here ?
Which one is true Orion Network Performance Monitor or Target server memory(Windows performance monitor)?
You can get detail SQL memory usage by SQL command