Post reply

SQL Server memory consumption

  • May 1, 2007 at 2:15 pm

    #370972

    Hi All -

    What is the best way to find out SQL server (2000) memory consumption when AWE is enabled. B/c taskmanager is not AWE aware and reports wrong numbers.

    Regards

  • May 2, 2007 at 2:54 am

    #703744

    from BOL

    "Use System Monitor (Performance Monitor in Microsoft Windows NT® 4.0) to retrieve information on SQL Server memory usage and available memory. Task Manager does not provide accurate memory usage information for AWE. Therefore, the memory quoted for sqlservr.exe is not correct. To obtain the correct amount of SQL Server memory usage, you can use the Total Server Memory (KB) performance counter, activated through System Monitor, or select the memory usage from sysperfinfo."

    Regards

  • May 2, 2007 at 8:21 am

    #703819

    I don't remember where I got this from, but I this may help you out.

    SELECTcntr_value, counter_name

    FROMmaster..sysperfinfo PageSplitsSec (nolock)

    WHERE (object_name = 'SQLServer:Memory Manager'

    AND counter_name = 'Total Server Memory (KB)'

    AND instance_name = '')

    OR (object_name = 'SQLServer:Memory Manager'

    AND counter_name = 'Target Server Memory(KB)'

    AND instance_name = '')

    Live to Throw
    Throw to Live
    Will Summers

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply