Hi All,
I ran this query
SELECT object_name,counter_name,instance_name, (cntr_value/1024) as Memory_in_MB, cntr_type FROM sys.dm_os_performance_counters
WHERE counter_name IN ('Target Server Memory (KB)','Total Server Memory (KB)')
some servers Total server memory = target server memory --- is this normal ?
Or Total server < target server ,please let me know which values are preferrable