Below is a script that you can use to retrieve your DB Server’s Physical Memory
CREATE TABLE #SVer(ID int, Name sysname, Internal_Value int, Value nvarchar(512))
INSERT #SVer exec master.dbo.xp_msver
SELECT *
FROM #SVer
WHERE Name = 'PhysicalMemory'
GO
DROP TABLE #SVer
Leave a Reply