How to fetch the "Physical Memory Size" (RAM size) through SQL Server ? [Resolved]

Posted by Jasminej under Sql Server on 7/25/2012 | Points: 10 | Views : 1434 | Status : [Member] | Replies : 2
How to fetch the "Physical Memory Size" (RAM size) through SQL Server ?

Any query or logic in sql server ?

thanks in advance




Responses

Posted by: Pandians on: 7/25/2012 [Member] [MVP] Silver | Points: 50

Up
0
Down

Resolved
Check it out!
Create Table #SysInfo

(
[Id] INT,
Name VARCHAR(100),
IV BIGINT,
CV VARCHAR(1000)
)

INSERT #SysInfo
EXEC MASTER.dbo.xp_msver

SELECT IV [Physical Memory(MB)] From #SysInfo Where Name='PhysicalMemory'

DROP Table #SysInfo


Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Jasminej, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jasminej on: 7/25/2012 [Member] Starter | Points: 25

Up
0
Down
Thank you very much!

Jasminej, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response