Questions
A) If I have the /3GB /PAE variables in the Win 2k Server boot.ini and only have 2 gig of memory will this cause issues with memory readings I am seeing in Performance Monitor? (I know it doesn't make sense to have but happened out of circumstance
B) From what I am reading if "SQLServer: Memory Manager -- Target Server Memory (KB)" provides the same value as "SQLServer: Memory Manager -- Total Server Memory (KB)" then SQL is content and has as much memory as it needs. What I am seeing on my SQL server is that the two numbers match but are using all the memory on the server which is 2 GB. I assume that this means increase the amount of memory on the box. Am I correct in this assumption
C) Again from reading my understanding is that when using AWE (under 16 GB), SQL at startup will grab the specified chunk of RAM you have alotted to it. I was wondering if there are any counters within Performance Monitor that will tell me exactly how much of that RAM (AWE) SQL Server is using
Thanks...Anyone?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment