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 : 2445 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Any query or logic in sql server ?

thanks in advance

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	Thank you very much! Jasminej, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts