September 15, 2002 at 9:06 pm
I just put in the /3GB switch into boot.ini. I want to verify that indeed SQL Server now sees 3GB. Beforehand, I looked at the memory SQL thought it had via EM, it showed all memory on machine (i.e. 4GB). Is there anyway to prove that the /3GB has taken affect?
September 16, 2002 at 1:34 am
Try checking what it says in SQL:
select * from master..sysperfinfo where counter_name = 'Total Server Memory (KB)'
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
September 18, 2002 at 7:42 pm
This gives me: Counter Value = 1,125,344 Counter Type = 65,536
What can I conclude about main memory that SQL Server sees (i.e. can use)?
September 19, 2002 at 1:28 am
It seems it uses just above 1 GB of memory. But this is the amount of memory it uses, not what it sees (sorry, didn't notice that this was what you asked about until now). Try setting the amount of memory allocated to SQL to more than 2 GB, then you'll see if it works.
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply