dbTalk Databases Forums  

MSDTC

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss MSDTC in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
GDP
 
Posts: n/a

Default MSDTC - 02-26-2008 , 02:00 PM






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



Reply With Quote
  #2  
Old   
Justin Rich
 
Posts: n/a

Default Re: MSDTC - 02-27-2008 , 08:22 AM






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

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/ar.../04/84199.aspx

How to configure DTC - not that you asked, but i know i learned a few things
from it (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/lib...12(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

Justin



"GDP" <gdpmamm (AT) hotmail (DOT) com> wrote

Quote:
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




Reply With Quote
  #3  
Old   
Justin Rich
 
Posts: n/a

Default Re: MSDTC - 02-27-2008 , 08:22 AM



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

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/ar.../04/84199.aspx

How to configure DTC - not that you asked, but i know i learned a few things
from it (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/lib...12(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

Justin



"GDP" <gdpmamm (AT) hotmail (DOT) com> wrote

Quote:
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




Reply With Quote
  #4  
Old   
Justin Rich
 
Posts: n/a

Default Re: MSDTC - 02-27-2008 , 08:22 AM



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

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/ar.../04/84199.aspx

How to configure DTC - not that you asked, but i know i learned a few things
from it (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/lib...12(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

Justin



"GDP" <gdpmamm (AT) hotmail (DOT) com> wrote

Quote:
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




Reply With Quote
  #5  
Old   
Justin Rich
 
Posts: n/a

Default Re: MSDTC - 02-27-2008 , 08:22 AM



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

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/ar.../04/84199.aspx

How to configure DTC - not that you asked, but i know i learned a few things
from it (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/lib...12(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

Justin



"GDP" <gdpmamm (AT) hotmail (DOT) com> wrote

Quote:
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




Reply With Quote
  #6  
Old   
Justin Rich
 
Posts: n/a

Default Re: MSDTC - 02-27-2008 , 08:22 AM



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

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/ar.../04/84199.aspx

How to configure DTC - not that you asked, but i know i learned a few things
from it (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/lib...12(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

Justin



"GDP" <gdpmamm (AT) hotmail (DOT) com> wrote

Quote:
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




Reply With Quote
  #7  
Old   
Justin Rich
 
Posts: n/a

Default Re: MSDTC - 02-27-2008 , 08:22 AM



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

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/ar.../04/84199.aspx

How to configure DTC - not that you asked, but i know i learned a few things
from it (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/lib...12(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

Justin



"GDP" <gdpmamm (AT) hotmail (DOT) com> wrote

Quote:
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




Reply With Quote
  #8  
Old   
Justin Rich
 
Posts: n/a

Default Re: MSDTC - 02-27-2008 , 08:22 AM



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

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/ar.../04/84199.aspx

How to configure DTC - not that you asked, but i know i learned a few things
from it (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/lib...12(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

Justin



"GDP" <gdpmamm (AT) hotmail (DOT) com> wrote

Quote:
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




Reply With Quote
  #9  
Old   
Justin Rich
 
Posts: n/a

Default Re: MSDTC - 02-27-2008 , 08:22 AM



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

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/ar.../04/84199.aspx

How to configure DTC - not that you asked, but i know i learned a few things
from it (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/lib...12(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

Justin



"GDP" <gdpmamm (AT) hotmail (DOT) com> wrote

Quote:
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




Reply With Quote
  #10  
Old   
Justin Rich
 
Posts: n/a

Default Re: MSDTC - 02-27-2008 , 08:22 AM



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

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/ar.../04/84199.aspx

How to configure DTC - not that you asked, but i know i learned a few things
from it (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/lib...12(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

Justin



"GDP" <gdpmamm (AT) hotmail (DOT) com> wrote

Quote:
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




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.