Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

MSDTC

 
   Database Forums (Home) -> Clustering RSS
Next:  problem with connecting to sql server via a wirel..  
Author Message
GDP

External


Since: Feb 26, 2008
Posts: 2



(Msg. 1) Posted: Tue Feb 26, 2008 6:00 pm
Post subject: MSDTC
Archived from groups: microsoft>public>sqlserver>clustering (more info?)

I have 2 nodes Windows Server 2003 R2 Enterprise x64 Edition with Service
Pack 2.

I need to install SQL2005 Standard Edition with multiples instances.
Each instance has its own one Cluster Group.

I am installing MSDTC in cluster and I need to assign a LUN.
So, which is the recommended size (kb) for this service?

Thanks for the help!

GDP

 >> Stay informed about: MSDTC 
Back to top
Login to vote
Justin Rich

External


Since: Jul 23, 2007
Posts: 17



(Msg. 2) Posted: Wed Feb 27, 2008 9:22 am
Post subject: Re: MSDTC [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Personally i dont have much experience with DTC so its hard for me to say...
I thought i would just provide what info i could Smile

What is DTC - states, in the comments, the disk should be at least 4MB, but
doesnt say how much larger it needs to be
http://blogs.msdn.com/florinlazar/archive/2004/03/04/84199.aspx

How to configure DTC - not that you asked, but i know i learned a few things
from it Smile (thanks to Linchi Shea for the link)
http://support.microsoft.com/kb/301600/

DTC Log files (says its a 4MB log)
http://msdn2.microsoft.com/en-us/library/ms687612(VS.85).aspx

Based on the reading i just did (mostly those links) it sounds like the log
file is the only thing of importance so i would imagine you would want to do
something like that.

Depending on how much disk you have laying around you might want to consider
500MB (the smallest optimal NTFS disk size) just for performance reasons.

If your tight on disk space and my assumption of the log file being the only
real data, you might want to go with 10MB or so

Dont forget to align your disk Wink

Justin



"GDP" wrote in message

>I have 2 nodes Windows Server 2003 R2 Enterprise x64 Edition with Service
>Pack 2.
>
> I need to install SQL2005 Standard Edition with multiples instances.
> Each instance has its own one Cluster Group.
>
> I am installing MSDTC in cluster and I need to assign a LUN.
> So, which is the recommended size (kb) for this service?
>
> Thanks for the help!
>
> GDP
>

 >> Stay informed about: MSDTC 
Back to top
Login to vote
GDP

External


Since: Feb 26, 2008
Posts: 2



(Msg. 3) Posted: Wed Feb 27, 2008 5:10 pm
Post subject: Re: MSDTC [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi Justin !

Thanks a lot !!

Best Regards.

GDP.

"Justin Rich" wrote in message

> Personally i dont have much experience with DTC so its hard for me to
> say... I thought i would just provide what info i could Smile
>
> What is DTC - states, in the comments, the disk should be at least 4MB,
> but doesnt say how much larger it needs to be
> http://blogs.msdn.com/florinlazar/archive/2004/03/04/84199.aspx
>
> How to configure DTC - not that you asked, but i know i learned a few
> things from it Smile (thanks to Linchi Shea for the link)
> http://support.microsoft.com/kb/301600/
>
> DTC Log files (says its a 4MB log)
> http://msdn2.microsoft.com/en-us/library/ms687612(VS.85).aspx
>
> Based on the reading i just did (mostly those links) it sounds like the
> log file is the only thing of importance so i would imagine you would want
> to do something like that.
>
> Depending on how much disk you have laying around you might want to
> consider 500MB (the smallest optimal NTFS disk size) just for performance
> reasons.
>
> If your tight on disk space and my assumption of the log file being the
> only real data, you might want to go with 10MB or so
>
> Dont forget to align your disk Wink
>
> Justin
>
>
>
> "GDP" wrote in message
>
>>I have 2 nodes Windows Server 2003 R2 Enterprise x64 Edition with Service
>>Pack 2.
>>
>> I need to install SQL2005 Standard Edition with multiples instances.
>> Each instance has its own one Cluster Group.
>>
>> I am installing MSDTC in cluster and I need to assign a LUN.
>> So, which is the recommended size (kb) for this service?
>>
>> Thanks for the help!
>>
>> GDP
>>
>
>
 >> Stay informed about: MSDTC 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
MSDTC is does not respond - Hi All- We have a MSDTC issue in our cluster. If I make any cross database calls in the cluster instance, I get an error related with MSDTC [Error text is similar to "MSDTC is not running in the given instance"] I notice that the MSDTC Lo...

MSDTC with SQL Server 2000 - Hi, I have a three nodes cluster with Win 2003. On that I have four SQL intances. MSTDC is installed on the Quorum. When a failover happens, the SQL groups start before MSDTC and that create a problem with the transactions after. To assure a good..

MSDTC Troubles, Do I Even Need It? - I am running a two node cluster. The failover node had a hardware failure and I had to re-install Windows. I have been trying to add the node back into the cluster for 3 days and it continually fails with MSDTC. Mostly it's been complaining that a..

MSDTC Required? - I am preparing for the installation of SQL Server 2005 Standard on a two-node cluster. The SQL Server books Online" topic named "Before Installing Failover Clustering" indicates that you must install MSDTC if you are installing the Dat...

MSDTC Config - so although I have read a few things in both directions, it seems I need the MSDTC for a SQL cluster. When I create it I have to assign dependencies to a drive and name. By default, when a cluster is built there is "group 0" which is my share...
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]