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 ?
  2. Luis Martin Moderator

  3. joechang New Member

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


    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
  4. LanLan New Member


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

  5. joechang New Member

    just make sure the os is not paging if sql used too much memory

Share This Page