Can you please try to run this query and let me know the response: -
"SELECT (physical_memory_in_use_kb/1024) AS Used_Memory_By_SqlServer_MB
FROM sys.dm_os_process_memory"
I am certified in MCSE 2012, Have more than 12 years of System Administration.
I am systems administrator with over 12 years of experience managing server infrastructures and data-center operations across multiple platforms (mostly Microsoft, partially Linux) mostly in virtualized environment (both Hyper-V and VMWARE). Experienced in Web and Email hosting deployment and customer support. Effectively plan, install, configure and optimize the IT infrastructure to consistently achieve high availability and performance. Certified in MCSE 2012, VCP6-DCV and CCNA.
I will be glad to help you.