Re: SQL 2008 Installation
- From: "Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx>
- Date: Wed, 15 Jul 2009 09:41:10 -0400
It Depends.
As long as the instance count is less than 2x the node count, ine MSDTC per Instance is a good setting. Over that, you will get better resource management with one MSDTC instance per node.
GNH
"John" <John@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:0B3EE5E5-4F46-4FAC-91E7-84B6CAE54534@xxxxxxxxxxxxxxxx
Ok Great,
But in a cluster with more than one SQL instance makes sence to have one
MSDTC per SQL Cluster Instance, or have only one MSDTC in a dedicated
resource?
Thank you.
"Geoff N. Hiten" wrote:
That is a valid scenario. Personally, I prefer having the DTC resource
inside the SQL Application or Service. That way there is always a DTC
resource local to the instance. Thta cuts down on unnecessary inter-node
traffic.
The advantage of a dedicated MSDTC resource is you can put it on a more
lightly loaded node in a multi-node cluster. That is only important if
there is a very large DTC load.
--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP
"John" <John@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7CD1899D-DD75-4FF9-9AC8-09AB26182B09@xxxxxxxxxxxxxxxx
> Hi Geoff,
> Almost done :)
> I've one more question if you don't mind.
>
> The MSDTC is assigned to my cluster name and IPAddress, but after some
> additional reading, I read that in some scenarios the DTC Disk resource > is
> configured outside of the SQL Resource group??!!!!
>
> My DTC configuration is using the Network name and ip address of the > SQL
> cluster, and I assigned a Disk resource that is also inside the same > SQL
> Resource Group, should I place the MSDTC Disk resource in a dedicated
> Resource group? If yes, what are the advantages?
>
> Thank you again.
>
>
>
> "John" wrote:
>
>> Okay, thanks, I'll give it a try and post the results.
>> Thank you for your help.
>>
>> "Geoff N. Hiten" wrote:
>>
>> > Inline.
>> >
>> >
>> > "John" <John@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> > news:9708AC01-73C3-4563-B2DE-C474A8B333C4@xxxxxxxxxxxxxxxx
>> > > Hi Geoff and thank you for your response.
>> > >
>> > > Okay, I read your article, if I understand your thoughts >> > > correctly:
>> > >
>> > > - MSDTC should be in each Cluster group for each instance of SQL
>> > > (does
>> > > this
>> > > apply to both SQL 2005 and 2008 right?).
>> > Yes. I wrote that post before SQL 2008, but the same thought >> > process
>> > and
>> > rules apply.
>> >
>> > > -MSDTC should use the VS name and IP address that was used in that
>> > > Cluster
>> > > group (I mean, you can associate to the networkname and ipaddress
>> > > that's
>> > > being used to SQL server as long as you don't associate with SQL
>> > > server
>> > > resources, right?)
>> > >
>> > Exactly. This is to prevent problems during subsequent SQL Updates.
>> >
>> >
>> > > To install SQL 2008, I'm following the KB 955392 to slipstream SP1
>> > > and
>> > > Update the SQL Server 2008 Setup support files.
>> > >
>> > You can slipstream or pre-patch. Your choice.
>> > > You say that I need to start with integrated installation? What
>> > > option is
>> > > that? "Installation" menu or Advanced menu? Do I need to run in >> > > both
>> > > nodes
>> > > or
>> > > just one? In SQL 2005 I needed to create a Cluster group with at
>> > > least one
>> > > disk resource in it, is this still true for SQL 2008?
>> > >
>> >
>> > You start off by building the "base" node. After that you add to >> > the
>> > existing SQL cluster. Very similar to how yoo build a cluster in >> > the
>> > first
>> > place.
>> >
>> >
>> > > Thank you for your time and patience :)
>> > >
>> >
>> > You are welcome.
>> >
>> > > "Geoff N. Hiten" wrote:
>> > >
>> > >> Advanced is for sysprepped installations that will be duplicated
>> > >> many
>> > >> times.
>> > >>
>> > >> You need to start with Integrted installation.
>> > >>
>> > >> Before you start, you need to download and run SQL 2008 SP1. >> > >> This
>> > >> will
>> > >> patch the installation script, which has some cluster-related >> > >> bugs
>> > >> in the
>> > >> RTM version. You will still need to apply SP1 after the regular
>> > >> installation, since the "pre-patch" only fixes the install >> > >> script.
>> > >>
>> > >>
>> > >> Here is the official support policy for mixed version clusters:
>> > >> http://support.microsoft.com/kb/327518
>> > >>
>> > >> Here are my thoughts on MSDTC and Windows 2008 clustering.
>> > >> http://weblogs.sqlteam.com/geoffh/archive/2008/07/31/DTC-configuration-for-Windows-2008-SQL-2005-Clusters.aspx
>> > >>
>> > >> Hope this helps
>> > >>
>> > >>
>> > >> -- >> > >> Geoff N. Hiten
>> > >> Principal SQL Infrastructure Consultant
>> > >> Microsoft SQL Server MVP
>> > >>
>> > >>
>> > >>
>> > >>
>> > >> "John" <John@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> > >> news:132EA13B-1175-451A-8806-8D51D02C852B@xxxxxxxxxxxxxxxx
>> > >> > Hello Everyone,
>> > >> >
>> > >> > I'm trying to setup a 2 node SQL 2008 failover cluster in >> > >> > windows
>> > >> > 2008
>> > >> > (2
>> > >> > instances).
>> > >> >
>> > >> > After reading some documentation, I'm confused about the right
>> > >> > path to
>> > >> > follow.
>> > >> > I read that are 2 installation methods, Integrated and >> > >> > Advanced.
>> > >> >
>> > >> > When I start the DVD I select "Installation" and I have the >> > >> > option
>> > >> > "New
>> > >> > SQL
>> > >> > Server failover cluster installation".???!!!
>> > >> >
>> > >> > If I go to "Advanced" menu, I have "advanced cluster >> > >> > preparation"
>> > >> > and
>> > >> > "Advanced cluster completion"??!!
>> > >> >
>> > >> > What should I use? Should I run advanced cluster preparation" >> > >> > on
>> > >> > both
>> > >> > nodes
>> > >> > an them "Advanced cluster completion" on both nodes as >> > >> > well???!!!
>> > >> >
>> > >> > Can anyone point me the right direction to start with?
>> > >> >
>> > >> > Another question is related with having SQL 2008 in a cluster
>> > >> > where SQL
>> > >> > 2005
>> > >> > is already installed, is this supported? What precautions >> > >> > should I
>> > >> > have
>> > >> > in
>> > >> > a
>> > >> > scenario like this one?
>> > >> >
>> > >> > At last, Windows 2008 supports multiple instances of MSDTC.
>> > >> > Assuming
>> > >> > the
>> > >> > SQL
>> > >> > 2008 and SQL 2005 in a 2 node failover cluster, what is the >> > >> > right
>> > >> > way
>> > >> > to
>> > >> > setup MSDTC? Should I create a separate cluster group for MSDTC
>> > >> > for
>> > >> > each
>> > >> > instance of SQL? Or should I integrate a separate MSDTC cluster
>> > >> > reasource
>> > >> > in
>> > >> > each SQL cluster group??
>> > >> >
>> > >> > Thank you for your time.
>> > >> >
>> > >> >
>> > >>
>> > >>
>> >
>> >
.
- Follow-Ups:
- Re: SQL 2008 Installation
- From: John
- Re: SQL 2008 Installation
- References:
- Re: SQL 2008 Installation
- From: John
- Re: SQL 2008 Installation
- From: Geoff N. Hiten
- Re: SQL 2008 Installation
- From: John
- Re: SQL 2008 Installation
- Prev by Date: Re: SQL 2008 Installation
- Next by Date: Re: SQL 2008 Installation
- Previous by thread: Re: SQL 2008 Installation
- Next by thread: Re: SQL 2008 Installation
- Index(es):
Relevant Pages
|
