Getting Memory usage through T-SQL

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Adi Sapir
    #1

    Getting Memory usage through T-SQL

    I'm trying to get the machine free ram value using either T-SQL or
    SQL-DMO.
    I found .Registry.Physi calMemory which takes care of the total ram but
    I still need eithrt the free or the used.

    Any ideas?
    Thanks!

    Tags: None
    • Simon Hayes
      #2
      Re: Getting Memory usage through T-SQL

      "Adi Sapir" <adisapir@gmail .com> wrote in message news:<ce7ucv$rg 7@odbk17.prod.g oogle.com>...[color=blue]
      > I'm trying to get the machine free ram value using either T-SQL or
      > SQL-DMO.
      > I found .Registry.Physi calMemory which takes care of the total ram but
      > I still need eithrt the free or the used.
      >
      > Any ideas?
      > Thanks![/color]

      You should probably look at WMI for this, as it's intended for
      retrieving this kind of system-level information:

      http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=Pzimb.191%24PL1.121%40reader1.news.jippii.net


      Simon

        Comment

        Previous template Next
        Working...