SQL Server Performance Forum – Threads Archive

Check Memory Usage with AWE enabled

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 ?

One to read: http://www.sql-server-performance.com/sql_server_performance_audit.asp Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

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

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

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

]]>