SQL Server Performance

Check Memory Usage with AWE enabled

Discussion in 'Performance Tuning for Hardware Configurations' started by LanLan, Jul 10, 2006.

  1. LanLan New Member

    We have a dedicated SQL Cluster with 8GB memory, AWE enabled, 4 processors. It's passive/active Recently, we have users complain the slowness of the system. What counters should I use to see whether it is a Memory or Process issue ?
    LanLan, Jul 10, 2006
    #2

  2. Luis Martin Moderator

    Luis Martin, Jul 10, 2006
    #2

  3. joechang New Member

    you might also try my list of performance counters, there a few not on Brad's list

    http://www.sql-server-performance.com/qdpma/instructions.asp

    also, be alert to the situation where it is slow due to traceable causes, or horribly slow for no apparent cause, this is a special situation for which there are good documents explaining why and how to resolve
    joechang, Jul 10, 2006
    #2

  4. LanLan New Member

    thanks..

    Since this OS has AWE enabled which maps & unmaps memory, anything I should pay particular attention ?


    LanLan, Jul 10, 2006
    #2

  5. joechang New Member

    just make sure the os is not paging if sql used too much memory
    joechang, Jul 10, 2006
    #2

Share This Page