Just remember, depending on which OS you are using there are limitations as
to what SQL will see for resources:
- up to 32 CPU on the Windows 2000 DataCenter
- up to 8 CPU on the Windows 2000 Advanced Server
- up to 4 CPU on the Windows NT Server 4.0 Enterprise Edition and on the
Windows 2000 Server
- up to 64Gb RAM on the Windows 2000 DataCenter
- up to 8 Gb RAM on the Windows 2000 Advanced Server
- up to 4 Gb RAM on the Windows 2000 Server
- up to 3 Gb RAM on the Windows NT Server 4.0 Enterprise Edition
- up to 2 Gb RAM on the Windows NT Server 4.0
-----Original Message-----
From: daniel [mailto:mssqldba-ezmlmshield-x42985690.[Email address protected]
Sent: Friday, December 29, 2006 9:00 AM
To: LazyDBA Discussion
Subject: Re: Failover Cluster
Hi Scott
I asume you are talking about Microsoft SQL Server on SUN x64 Hardware
with Windows 2003 Server OS
clustered with Microsoft Cluster Service ...
In a failover case the SQL Server Service on Node 1 will be stopped and
the Disk Drives containing the Data will be switched to Node 2.
Then the SQL Server Service will be started on Node 2.
If you are not configuring a processor mask SQL Server will use
dynamically as many processors and memory as are available on the Node.
So no problem with that.
Regards
Daniel
mssqldba-ezmlmshield-x49131255.[Email address protected]
29.12.2006 14:29
To
[Email address protected]
cc
Subject
Failover Cluster
We are planning to implement a new failover cluster to replace the
existing
cluster. New new boxes are Sun with sixteen processor with thirty two gig
of ram. Because we are trying to avoid waste, the second node will be
virtualized which will leave the failover portion with only four procs and
eight gig of ram. For emergency situations, this will be sufficient.
However, I donšt know how SQL Server will react to losing twelve procs and
twenty four gig during the failover. Will the failover work or will it
cause server confusion?
Thanks,
Scott Tyree
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
**********************************************************************
This e-mail may contain confidential material. It is intended only for the
person or entity which it is addressed to. Any review, retransmission,
dissemination or other use of this information by persons or entities other
than the intended recipient is prohibited. If you received this e-mail in
error, please immediately notify the sender or The Swiss Raiffeisen Group
and delete the material from any and all computers it may be stored on. Any
views or opinions expressed in this e-mail are those of the sender and do
not necessarily coincide with those of The Swiss Raiffeisen Group. Therefore
this e-mail does not represent a binding agreement nor an offer to deal.
E-mail transmission cannot be guaranteed to be secure or error-free.
Information could be intercepted, corrupted, lost, destroyed, incomplete or
may contain viruses. Neither The Swiss Raiffeisen Group nor the sender can
accept any liability for any kind of damage as the result of viruses or
transmission errors.
**********************************************************************
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page