Great Script.. Thank You. Can you add direction on how to take your script results and have it use the MAX MEM (SQLMaxMemoryMegaByte) results to automatically change/update the SQL settings (i.e. sp_configure max server memory)?
Not sure why you want to automatically change the memory setting. Since you don't need to do this often, I would recommend just executing the script and then copy/paste the results to make you memory change.