Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Clustering / September 2006

Tip: Looking for answers? Try searching our database.

How much disk for ms-dtc cluster resource ?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
andrea cuozzo - 14 Sep 2006 12:17 GMT
hello,

I'm about to install a 2-nodes Windows 2003 Cluster, with 2 SQL Server 2005
instances: I've read in MS documentation that clustering MS-DTC is
recommended, but I can't find how much disk space shoud I reserve for it
group: can you tell me what is the recommended disk space for it ?

thanks

andrea, Italy
Tom Moreau - 14 Sep 2006 12:22 GMT
It doesn't need much.  Even 500MB should be fine.

Signature

  Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON   Canada
.

hello,

I'm about to install a 2-nodes Windows 2003 Cluster, with 2 SQL Server 2005
instances: I've read in MS documentation that clustering MS-DTC is
recommended, but I can't find how much disk space shoud I reserve for it
group: can you tell me what is the recommended disk space for it ?

thanks

andrea, Italy
andrea cuozzo - 14 Sep 2006 12:34 GMT
thans a lot

andrea

> It doesn't need much.  Even 500MB should be fine.
>
[quoted text clipped - 9 lines]
>
> andrea, Italy
Russ Kaufmann - 15 Sep 2006 16:00 GMT
> hello,
>
> I'm about to install a 2-nodes Windows 2003 Cluster, with 2 SQL Server
> 2005 instances: I've read in MS documentation that clustering MS-DTC is
> recommended, but I can't find how much disk space shoud I reserve for it
> group: can you tell me what is the recommended disk space for it ?

Unless you are using two phase commits, don't waste the physical disk
resource. Put it on your quorum.

Signature

Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

Linchi Shea - 15 Sep 2006 18:36 GMT
If MSDTC is going to be used at all, I don't believe putting it on quorum is
a practice recommended by Microsoft, although it seems to be work fine in all
my tests. Becuase of the Microsoft recommendation, we have chosen to create a
640MB LUN just for this purpose and create a seperate group for MSDTC. Once
this is made a standard practice, there is little waste to speak of.

Linchi

> > hello,
> >
[quoted text clipped - 5 lines]
> Unless you are using two phase commits, don't waste the physical disk
> resource. Put it on your quorum.
Rodney R. Fournier [MVP] - 15 Sep 2006 18:49 GMT
That Best Practice has been changed a million times via 301600. It is
perfectly acceptable to place in it the cluster group for lite usage or
Exchange.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner

> If MSDTC is going to be used at all, I don't believe putting it on quorum
> is
[quoted text clipped - 18 lines]
>> Unless you are using two phase commits, don't waste the physical disk
>> resource. Put it on your quorum.
Russ Kaufmann (MVP) - 19 Sep 2006 01:57 GMT
> If MSDTC is going to be used at all, I don't believe putting it on quorum
> is
> a practice recommended by Microsoft

It is perfectly fine to put it in the default cluster group. THe only time
that it is recommended to put it in its own group with its own resources is
if it is heavily used. Read here for more:

http://msmvps.com/blogs/clusterhelp/archive/2005/08/05/61718.aspx

Signature

Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp class is in NYC starting Dec 4th. Come and enjoy
training in NYC.

Linchi Shea - 28 Sep 2006 14:10 GMT
Russ and Rodney;

Thanks for pointing out the change in the fine print of the KB article.

Linchi

> > If MSDTC is going to be used at all, I don't believe putting it on quorum
> > is
[quoted text clipped - 5 lines]
>
> http://msmvps.com/blogs/clusterhelp/archive/2005/08/05/61718.aspx
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.