SQL Server Performance

Memory Related

Discussion in 'Performance Tuning for DBAs' started by Unsure, Sep 16, 2008.

  1. Unsure New Member

    RAM is 32GB. Memory allocated to SQL Server is 30GB. AWE is enabled.

    What should the Performance Counter - 'Total Memory' for the SQL Server display?

    Also, what should 'Committed' on execution 'dbcc memorystatus' display?

    Doesn't 'Hashed' and 'Free' from 'dbcc memorystatus' help to determine the amount of 'Used' and Available' Buffers?

    Don't require an explanation of the above just what the stats should display.

    Thank you.
  2. satya Moderator

  3. Unsure New Member

    Thanks. Did read that.
    We are using SQL Server 2000.
    Just wanted confirmation based on what I read.

Share This Page