Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2002
    Posts
    11

    Unanswered: 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,

    Sasan

  2. #2
    Join Date
    Feb 2003
    Location
    L.A
    Posts
    3

    Re: How to get the available memory on the server?

    Originally 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.

  3. #3
    Join Date
    Jul 2002
    Posts
    11

    Re: How to get the available memory on the 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!

  4. #4
    Join Date
    Feb 2003
    Location
    L.A
    Posts
    3

    Re: How to get the available memory on the server?

    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'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •