Home Forums SQL Server 2005 Administering AWE SQL 2005 Standard Clustering RE: AWE SQL 2005 Standard Clustering

  • July 3, 2009 at 12:32 am

    #1019623

    for configured

    use master

    select * from sysperfinfo where counter_name like '%target server memory%'

    currently used

    use master

    select * from sysperfinfo where counter_name like '%total server memory%'

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]