Solved

sql2005 std edition  32 bit with 8GB memory

Posted on 2011-03-03
1
352 Views
Last Modified: 2012-05-11
Hi,
We currently have sql2005 std edition on win 2003 ent edition.  We have 8GB of memory and plan for another 8GB extension, so 16GB in total. SO do I need to change anything in boot.ini ? our boot.ini look like below then sql2005 awe enabled set to 1 with no lock pages memory set .

[boot loader]
redirect=UseBiosSettings
timeout=5
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /noexecute=optout /fastdetect /redirect /PAE
0
Comment
Question by:motioneye
1 Comment
 
LVL 15

Accepted Solution

by:
Aaron Shilo earned 500 total points
ID: 35027678
no need to change anything
you have the :  /PAE  switch and you configured AWE in SS so your good.
 
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question