How to get available memory using SQL

Question

Post reply

How to get available memory using SQL

Jimmy Jen

SSCrazy

Points: 2915
More actions
March 1, 2005 at 10:57 am

#102409

Does anyone knows how to get available physical memory using SQL ? Thanks.
-Jimmy

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Carl Federl One Orange Chip Points: 25384 More actions · Answer 1

exec master.dbo.xp_msver 'PhysicalMemory'

SQL = Scarcely Qualifies as a Language

Jimmy Jen SSCrazy Points: 2915 More actions · Answer 2

Thanks for trying but this xp only provides total physical memory installed. I'm looking for available physical memory.

Gabor Nyul SSCrazy Eights Points: 9459 More actions · Answer 3

Target Server Memory(KB) and Total Server Memory (KB) values in the master..sysperfinfo table?

Bye
Gabor

Jimmy Jen SSCrazy Points: 2915 More actions · Answer 4

Thanks Gabor.

How often this system table is updated ?

Thanks again,

Jimmy

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

It's not a table : run this in the master table

Select objectproperty(object_id('sysperfinfo'), 'TableIsFake')

It will return 1. This means than when you query that table, Sql server meterializes it so that the query can execute, but this information is never actually kept on the hd like a real table.

checks BOLS : objectproperty::TableIsFake