SQL Server Performance Forum – Threads Archive
Check Memory Usage with AWE enabledWe 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
SQL-Server-Performance.com All in Love is Fair
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