RAM value from QA - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

RAM value from QA

Author

Topic

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-03-14 : 11:14:08

Is there a XP, or some sort of function which gives the RAM on a server USING QA?

------------------------
I think, therefore I am - Rene Descartes

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-03-14 : 11:42:43

[code]SELECT Name,
Minimum,
Maximum,
Value_In_Use
FROM sys.configurations
WHERE Configuration_ID IN (1543, 1544)[/code]

E 12°55'05.25"
N 56°04'39.16"

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-03-14 : 12:34:22

The query gives the SQL SERVER settings; I need to know the available RAM on the server.

------------------------
I think, therefore I am - Rene Descartes

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-14 : 12:56:35

Right click :
My computer : Properties:

you will find total Ram of server.

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-03-14 : 13:09:37

I know that ;-)

I have around 30 servers, I need to do some sort of automation....

------------------------
I think, therefore I am - Rene Descartes

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-03-14 : 15:09:56

You could make a linked server or maybe use WMI?

E 12°55'05.25"
N 56°04'39.16"

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-03-14 : 15:16:25

Thanks Peso; probably that will work. I have never tried WMI. Thanks anyway.

------------------------
I think, therefore I am - Rene Descartes

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2008-03-14 : 15:33:58

As a quick workaround, you can use the free sysinternals command, PSINFO, to get the memory and a lot of other info.


psinfo \\MyServer

PsInfo v1.73 - Local and remote system information viewer
Copyright (C) 2001-2005 Mark Russinovich
Sysinternals - www.sysinternals.com

System information for \\MyServer:
Uptime:                    99 days 19 hours 51 minutes 11 seconds
Kernel version:            Microsoft Windows Server 2003, Multiprocessor Free
Product type:              Standard Edition
Product version:           5.2
Service pack:              2
Kernel build number:       3790
Registered organization:   MyCompany
Registered owner:          MyCompany
Install date:              8/23/2007, 2:25:24 AM
Activation status:         Error reading status
IE version:                7.0000
System root:               C:\WINDOWS
Processors:                4
Processor speed:           3.0 GHz
Processor type:            Intel(R) Xeon(R) CPU
Physical memory:           5500 MB
Video driver:              ATI ES1000

CODO ERGO SUM

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-03-14 : 15:48:36

This is really great! Thanks MVJ. I will run the tool for my servers and probably write a textpad macro to filter the necessary infomration.

------------------------
I think, therefore I am - Rene Descartes

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-03-14 : 17:50:12

Just a note for using the sysinternals applications.
First time application is run, you have to click ok to accept.
This can lead to problems if server is not the machine were you are at the moment. If not, you have to use Remote Desktop to logon to the sql server and there click ok before exection continues in ssms/em.

This behaviour was not there before. This was added when Sysinterals were incorporated by Microsoft.

E 12°55'05.25"
N 56°04'39.16"

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-03-14 : 17:57:55

I noticed that, thansk Peso.

------------------------
I think, therefore I am - Rene Descartes

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-03-14 : 18:16:14

Or this approach?

select physical_memory_in_bytes from sys.dm_os_sys_info

E 12°55'05.25"
N 56°04'39.16"

ravilobo
Master Smack Fu Yak Hacker

1184 Posts