Is there any way to find how much how much memory the single sqlserver instance is actually using in the node? I can see the max memory allocated is 50MB for my instance.But here i want to know hw much actually the instance is using.Can anyone help me on this.
Execute below query on your SQL Server instance:
SELECT CASE counter_name
WHEN 'Target Server Memory (KB)' THEN 'MemoryAssignedToSQLServer'
WHEN 'Total Server Memory (KB)' THEN 'MemoryUsedBySQLServer'
END AS Property,
(cntr_value/1024) AS Value_MB
WHERE counter_name IN ('Target Server Memory (KB)','Total Server Memory (KB)')
Hope this helps.