Hi All, We have a environment with 512GB of RAM and have given MAXSERVER MEMORY as 450GB. I am looking for a script to find the below components and need an alert mechanism depending up on it. -> Total Physical Memory in OS level. -> Total Available Memory in OS level. -> Total Max Server Memory set to SQLSERVER. -> Total Available Memory for SQLSERVER among the 450GB of MAXSERVER MEMORY. -> Total available free space among used memory of sql server. The output of the script as below. 1. Total Available OS Physical Memory 2. SQL Server MAXServer Memory 3. Total Available OS Physical Memory 4. Total Available SQLSERVER Memory among Total sql server maxserver memory 5. Total Free Space Among Used Memory by SQLSERVER. Please share any script is available for monitoring the above. I have a following doubts can anyone clarify the same. -> We have given 450GB MAXMEMORY to SQL SERVER among the total physical memory of 512GB. The SQLSERVER already occupies 446GB among 450GB but used is only 440GB another 46GB is free space. This information grabbed from IDERA. -> How we can will get the informatoin as above by script. Environment details: SQLSERVER 2014 PHYSICAL SERVER MEMORY: 512GB MAXSERVER MEMORY: 450GB Regards, Narendra.