whats the Difference between committed memory and physical mem in use in sqlserver
Question
Saturday, January 19, 2019 2:34 AM
Hi MSDN,
Apart from total memory of my machine which is 8GB, what is the difference between these two columns(assuming second one is memory used by sqlserver I guess)? Any help is greatly appreciated.
Thanks.
FYI
All replies (2)
Sunday, January 20, 2019 6:03 AM ✅Answered | 1 vote
Good day Adi,
These dmv are documented and it is well explained. Please check the links to the official documents:
sys.dm_os_sys_info
/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-sys-info-transact-sql
sys.dm_os_process_memory
/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-process-memory-transact-sql
| Ronen Ariely [Personal Site] [Blog] [Facebook] [Linkedin] |
Monday, January 21, 2019 9:16 AM ✅Answered | 1 vote
Physical memory used by SQL Server is total amount of RAM(physical) used by SQL Server. A committed memory is one where virtual memory is backed by physical memory. When process starts in SQL Server is looks for memory in Virtual address space(VAS) region and is assigned memory from VAS, which is 8 TB for 64 bit system. After VAS memory is actually not committed unless that VAS regions is mapped to physical memory, once it does it is called committed memory. The term which is normally used is VMcommitted which means amount of virtual memory backed by physical RAM.
Cheers,
Shashank
Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it