February 9, 2010 at 11:26 pm
Hi friends,
i have 1 server with SQL server 2000 Enterprize edition (32 bit)SP4 (8.00.2282) installed on Windows Server 2003 Enterprize Edition SP2(32 bit)
Hardware
-----------
RAM 8GB
CPU 2 *2 (4 logical CPUs)
now i want to increase paging size to 1.5 times of RAM i.e 12GB
but its not allowing me to do so as PAE is not enabled
Kindly suggest step by step procedure to enable PAE &
Also any additional settings from SQL side(like AWE) & windows side(like lock pages in memory) if required?
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
February 10, 2010 at 5:11 am
Try Google.
Good search terms would be "enabling PAE Windows Server 2003" and "enabling AWE SQL 2005". Additionally you could look in Books Online.
Why is this urgent?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 10, 2010 at 9:51 am
"This dynamic AWE example does not apply to SQL Server 2000"
Try this, Check books online for more Info
sp_configure 'show advanced options', 1
RECONFIGURE
--To enable AWE
sp_configure 'awe enabled', 1
RECONFIGURE
GO
February 10, 2010 at 10:51 am
I got here as quick as I could.........:-)
in the awe enabled you will need reconfigure WITH OVERRIDE
yes enable lock pages in memory for the account SQL runs under.
set max memory in SQL to no more than 6GB. I don't have SQL2000 where I can check this but AWE is definitely not dynamic in SQL2000 so set min and max memory to the same value to fix the memory.
enable the /3GB switch on boot.ini. (as you only have 8Gb memory total)
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply