I'm planning to create a job that automatically gets the status of my server's RAM/memory at the time of the job's activation.
My job has the command:
use master insert into Rec.dbo.MemoryRec SELECT (physical_memory_in_use_kb/1024) AS Memory_usedby_Sqlserver_MB, (locked_page_allocations_kb/1024) AS Locked_pages_used_Sqlserver_MB, (total_virtual_address_space_kb/1024) AS Total_VAS_in_MB, process_physical_memory_low, process_virtual_memory_low , getdate() FROM sys.dm_os_process_memory;
Is this enough to monitor a server's RAM? Are there better queries that can be used?
Ps Please, as much as possible, do not suggest 3rd party programs because I currently cannot afford things like those