February 24, 2006 at 8:21 am
Dear all,
It has been a long time i am studying about SQL server memory and i think i know a bit about that.
We have a SQL Server installed on RAID 5 with 32 GB RAM and 4 CPU. SQL Server EM SP4
My problem is i had configured SQL Server for dynamic memory allocation and enabled AWE.
Boot .ini is configured to use RAM not defined the Limit.
Now the problem is that when i check the performance of SQL server through Windows Performance Monitor.
The 2 counter SQL Server :Memory Manager : Total Server Memory and
SQL Server : Memoery Manager:Target Server Memory Gives the same value .
The server should not give the same value for the 2 counter because there is 32 GB of RAM then why SQL server is looking for more memory.
as there is too much ram is free.
From]
Killer
February 24, 2006 at 10:31 am
You need to modify boot.ini to include /PAE switch and then enable MAX Server Memory in SQL Server. Shutdown SQL Service and restrat it.
February 24, 2006 at 8:22 pm
Hi Nitin ,
If u had looked into the question then u might not give me an answer as u had given me.
You need to modify boot.ini by /PAE switch
enable MAX Server Memory in SQL Server
I had written in my question i had configured SQL Server for dynamic memory allocation and enabled AWE.
Boot .ini is configured to use RAM not defined the Limit.
Restarted the Server after doing the above mentioned work.
Hope u understood my question
from
Killer
February 24, 2006 at 8:29 pm
Hi Nitin ,
If u had looked into the question then u might not give me an answer as u had given me.
You need to modify boot.ini by /PAE switch
enable MAX Server Memory in SQL Server
I had written in my question i had configured SQL Server for dynamic memory allocation and enabled AWE.
Boot .ini is configured to use RAM not defined the Limit.
Restarted the Server after doing the above mentioned work.
Hope u understood my question
from
Killer
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply