Home Forums SQL Server 2005 Administering SQL Server Alert to find the Physical server memory usage RE: SQL Server Alert to find the Physical server memory usage

  • You can query the sys.dm_os_performance_counters for object name = SQLServer:Memory Manager.

    It will give you Total Server Memory that SQL is using and Target Server Memory.

    Raymond Laubert
    Exceptional DBA of 2009 Finalist
    MCT, MCDBA, MCITP:SQL 2005 Admin,
    MCSE, OCP:10g