scweichel (6/26/2012)
Change these two lines in your script to make it 2012 compatible --- Read physical memory on server
SET @TotalMEMORYinBytes = (select physical_memory_kb from sys.dm_os_sys_info)
-- Coverting value from bytes to megabytes
SET @TotalMEMORYinMegaBytes = (@TotalMEMORYinBytes /(1024))
Thanks for the update and it seem to work just fine in 2012 now 🙂
Rudy