StartUp Options File for x64 SQL Cluster

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JT - 17 Mar 2006 07:57 GMT

Hi all,
I am setting up a 2 instance SQL 2K (32-bit with SP4) cluster on a 2 node
Win2003 x64 ENT cluster. Each node has 4 x 3.0 XEONs with 8MB L3 cache and
16 GB RAM. I am looking for info on any switch settings I should use in the
startup file for the servers to take advantage of the hardware. For example,

/PAE
/3GB
/LARGEADDRESSAWARE

Also, I want each instance to be able to reserve about 7GB of RAM per node.
Do I need to do anything with AWE to make this happen on this OS?

Thanks.

Signature

John

Reply to this Message

JT - 17 Mar 2006 08:03 GMT

Supplemental Note:
I now understand that the 64bit OS does NOT support either the /3GB or the
/PAE switch settings.

Signature

John

> Hi all,
> I am setting up a 2 instance SQL 2K (32-bit with SP4) cluster on a 2 node
[quoted text clipped - 10 lines]
>
> Thanks.

Reply to this Message

Geoff N. Hiten - 17 Mar 2006 17:09 GMT

More importantly, it doesn't need them.

You will need to enable AWE on each SQL instance and set the Maximum Server
Memory to the target value.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

> Supplemental Note:
> I now understand that the 64bit OS does NOT support either the /3GB or the
[quoted text clipped - 18 lines]
>>
>> Thanks.

Reply to this Message

Lukas - 22 Mar 2006 12:33 GMT

Hi

You only need to configure SQL to use the memory, how much memory is
available to SQL to use? You should see 16 GIG in Enterprise Manager.

On x64 the adressable memory is very large, so none of the /PAE or /3GB
switches were required.

Regards

> Hi all,
> I am setting up a 2 instance SQL 2K (32-bit with SP4) cluster on a 2 node
[quoted text clipped - 10 lines]
>
> Thanks.

Reply to this Message