473,320 Members | 1,969 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Help with Cluster

I inherited a SQL 2000 Enterprise active/passive cluster under AS. Both
nodes run on identical HP DL580's with 4 Xeon processors and 8GB memory.
The former dba attempted to setup AWE memory but missed a couple of fine
points. The first thing missed: the boot.ini only has the /PAE and no /3GB
switch. The second thing missed: sp_configure 'awe enabled' is set to 0.
As a result, SQL gets only 2GB of virtual memory and 0GB of PAE memory.

My question is how do I fix this on an active/passive cluster. Here is what
I think. Add the /3GB switch to the passive node and reboot the passive
node. Now it seems I am in trouble. If I pause the active node, I cause
the passive node to wake up, but the memory images do not match. If I start
with the active node and add the /3GB switch and reboot, I fail-over to the
passive. Everything is still OK, the memory matches until I reboot, then
the memory maps do not match.

So, do I break the cluster, install the /3GB switch on each box and then
recreate the cluster? Isn't there an easier way?

Also, can I enable AWE before I begin the /3GB shuffle. I seems I could
avoid a second dance.

Please help.

Gary
Jul 20 '05 #1
1 4739
Gary,

I can answer one of your questions.
Also, can I enable AWE before I begin the /3GB shuffle. I seems I could
avoid a second dance.


You do not need to use the "/3GB" switch in order to use AWE memory.
You may find an explanation of each switch helpful:

The "/PAE" switch allows Windows to use memory above the 4GB native
limit. So this switch is needed to enable Windows to address memory
above 4GB. (Additionally, you must use a Server Operating System that
supports more than 4GB. You're using Windows 2000 Advanced Server,
which allows up to 8GB to be addressed.)

The "/3GB" switch allows Windows applications to use 3GB out of the
4GB Windows supports natively thereby leaving 1GB of memory for the
Windows OS. By default (i.e., not using the "/3GB" switch),
applications will only use 2GB out of the first 4GB on the server and
leave 2GB for the Windows OS.

You have a total of 8GB of RAM. If you don't use the "/3GB" switch,
then SQL Server will still have 6GB of RAM available to use. You may
prefer to leave the 2GB available to the OS rather than take it for
SQL Server. But at you stated, you must set the "awe enabled" option
from "0" to "1" and restart the SQL Server service. In case you are
not aware, AWE does not dynamically manage memory like SQL Server does
by default, so if you have more than one instance of SQL Server
running on each node in the cluster, you may not want to use AWE
memory.

You may find the following link helpful:

AWE Memory SQL Server Performance Tuning Tips
http://www.sql-server-performance.com/awe_memory.asp

HOW TO: Configure Memory for More Than 2 GB in SQL Server
http://support.microsoft.com/default...B;EN-US;274750

Large Memory Support Is Available in Windows 2000 and Windows Server
2003
http://support.microsoft.com/default...;EN-US;q283037

SQL Server Books Online Topics "Managing AWE Support", "Effects of min
and max server memory"; "Memory Architecture"; "Memory Architecture";
"Server Memory Options"; "SQL Server Memory Pool"

I hope you find this information helpful.

Regards,

Matt Patterson
HP Services
Business Critical Enterprise Team
Microsoft Database Support
Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Leonardo C | last post by:
Hi: I'm trying to setup a MS Cluster but I don't know if it is feasible to configure it in the way I think. I have two machines with win2k server and MSSQL-2000 one of them is currently...
4
by: Jim Hubbard | last post by:
I have some C# code that is supposed to wrap the defrag APIs and I am trying to convert it to VB.Net (2003). But, I keep having problems. The C# code is relatively short, so I'll post it...
1
by: richardshen | last post by:
DB2 V8 on windows 2003 cluster server. DB2MSCS -f:db2.cfg DB2 instance is in the cluster now. DB2MSCS -u:db2 DB2 instance is in the local node now. I want to cluster the instance again DB2MSCS...
3
by: Shmulik | last post by:
I have an application written in C# that creates a queue of items to process, connects via a TCP connection to a server on a Unix box, and then passes data files to the Unix box for processing...
17
by: Peter Ericsson | last post by:
Does anyone know if Microsoft plans to implement an C# (.net) API for MS Cluster like the one in C++? Or has someone else written a C# wrapper for the C++ API?
4
by: ThunderMusic | last post by:
Hi, We have many servers setup as a cluster. When one server crashes, another one take the relay... We want to know if it's possible (I suppose it is) to make a Windows service developed with .NET...
3
by: Simon | last post by:
Hi All, I'm hoping someone will have some words of wisdom for me regarding MS Clustering on Windows 2003. I have a service that runs on a cluster. During invocation it's supposed to...
1
by: =?Utf-8?B?S2Vubnk=?= | last post by:
I have one bat file that contains a command to startup Java Program. Then, I would like to create a cluster job to call the bat file. In case of one computer is down, another computer can also call...
2
by: zakaria2710 | last post by:
Would u help me with this task, I am new in C++ programming, this codes have alot of errors, I have never work with graphs before, I am using Borlard C++ Ver 5.02. I was told u can not run a graph...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.