mjwlufc (12/18/2012)
The memory objects i'm lookin at are pages /sec and page faults/sec
Which pages/sec? Under which section? There are multiple pages/sec counters in different sections and they mean different things.
Since you're using 32 bit SQL, having AWE on is required to access more than 2 GB of memory.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability