How to get the available memory on the server?

Hi,
Is there a way to get the available memory on the system through SQL Server?
Thanks,
SasanOriginally posted by sassaidi
Hi,

Is there a way to get the available memory on the system through SQL Server?

Thanks,

Sasan

If all you want to do is find out how much memory the server has from SQL SERVER, from enterprise manager right click on the server - choose properties - from the dialog box select the memory tab. That will give you how much memory the server has and also allows you to configure the memory usage of SQL SERVER.|||Thanks for the reply. However, I need to automate this process. Basically I want to know if I can find the available memory by running a stored procedure (which will be called from an ASP page).

Thanks again!|||Originally posted by sassaidi
Thanks for the reply. However, I need to automate this process. Basically I want to know if I can find the available memory by running a stored procedure (which will be called from an ASP page).

Thanks again!

Here you go. This will do it. You can run the proc without any parameter as well to return all the information about your server.

exec master..xp_msver 'physicalMemory'