AWE is enabled on SERVER_ABC with 8GB RAM. Max memory is set to 5GB.
How do I know that the 5GB RAM is enough? Am I allocating too much memory for SQL?
Should I use perfmon to monitor? If yes, then what are the counters in the perfmon that I should use to monitor?
I noticed that there are AWE* counters under SQL Server:Buffer Manager, however I don't know how to read these counters. Are these counters reliable?