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

  • April 4, 2010 at 12:23 pm

    #1145494

    bigM (4/4/2010)

    So does this mean WMI query is the only approach to get the information (alert) about the memory usage of the physical server where the SQL Server resides.

    You can use Perfmon alerts but you could call the WMI query from within SQL Server, giving you the option of doing alerts.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton