the max server memory setting is 6.5 GB. 1) how can i determine how much exactly is being used by the sql server processes only? for example 6.5 GB is automatically assigned to sql server, but not all of that is needed. i have never been able to work out if there is a counter that can isolate this in performance monitor. this would be extremely handy to measure so memory settings could be set to allow the operating system optimum memory, and to complete a performance baseline. anyone know? 2) also, are there any DMVs for logging this info for versions 2005 and upwards?