December 19, 2003 at 6:21 am
We have new cluster server and total 8GB and have /3GB /PAE on boot.ini file, and awe enabled also, but server only see 2.6GB memory, we move all db from old server to this box, and even old box can see more memory close 6GB, any one know why? Or something else need configure on window 2000 advanced server?
Thanks
feifei liu
Rachel
December 19, 2003 at 6:30 am
You probably haven't given the service account the right to lock pages in memory. Check the local policy.
--Jonathan
--Jonathan
December 19, 2003 at 6:44 am
Yes, the service account SQL Server runs under needs to have this privilege as Jonathan indicates. Also ensure you've configured SQL Server to be able to use AWE memory:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
December 19, 2003 at 7:56 am
Thanks, That is our problem
feifei liu
Rachel
December 19, 2003 at 8:01 am
But do we need /3GB in the .ini file for window 2000 advanced server?
Thanks
feifei liu
Rachel
December 19, 2003 at 8:05 am
quote:
But do we need /3GB in the .ini file for window 2000 advanced server?Thanks
feifei liu
You don't need it, but it will improve performance.
--Jonathan
--Jonathan
December 19, 2003 at 8:14 am
The /3GB pushes drivers, etc., into an upper memory space and can limit the OS to only 1 GB of RAM. If your SQL Server needs that much, you can use it. The one issue with doing both had to do with a set of hotfixes MS released. But if yours is a new installation you shouldn't have that issue.
http://support.microsoft.com/default.aspx?scid=kb;en-us;817566
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply