June 27, 2012 at 9:46 am
I know that this is recommended...
"In Windows 2008 you can no longer make DTC dependent on the quorum disk so it either needs its own disk or can share with an application such as SQL Server. For the best performance you should give DTC its own disk."
So it should look something like below...
[Cluster Group]
Cluster IP Address
Cluster Name
Disk Q: (Quorum)
[SQL Group]
SQL Network Name
SQL IP Address
SQL Server (With dependencies of Disk D:, E: & F:)
Disk D: (Shared Drive, SQL Transaction Logs)
Disk E: (Shared Drive, SQL Temp Files)
Disk F: (Shared Drive, SQL Databases)
[DTC Group]
DTC Network Name
DTC IP Address
DTC Service (With dependencies of Disk G:)
Disk G:(DTC)
You could possibly combine SQL and DTC, but ideally they should be separate.
------------------------------------------------------------------------------------------------
However, my engineer is out on vacation and only gave me this...
D: 550GB SQL_Data
E: 550GB SQL_Logs
G: 50GB SQL Temp
Which all belong to the SQL Group as you know. Since I only have a DTC Hostname XXXCLSDTC and DTC IP 172.22.XX.XXX but no disk should I place DTC on one of the SQL Group Volumes? If so which one would be best? Or should I wait until someone can add another volume for DTC?
Thank you!
June 27, 2012 at 9:52 am
Vertigo44 (6/27/2012)
should I place DTC on one of the SQL Group Volumes?
If you do this you'll need to put the DTC resources in the same cluster group as the SQL resources
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 9:57 am
Perry Whittle (6/27/2012)
Vertigo44 (6/27/2012)
should I place DTC on one of the SQL Group Volumes?If you do this you'll need to put the DTC resources in the same cluster group as the SQL resources
Understood. Would One SQL Volume be more preferable than the others?
June 27, 2012 at 2:05 pm
Quick update: I ended up getting a disk presented to the server for DTC. I then added the disk though Cluster Failover Manager and added dependencys. I then failed it over and back with success.
Also, for those of you who may run into the following error when moving forward with the SQL Cluster Installation/Setup
--------------
Rule "Network binding order" generated a warning.
The domain network is not the first bound network. This will cause domain operations to run slowly and can cause timeouts that result in failures. Use the Windows network advanced configuration to change the binding order.
-----------------
Going to Network Connections and selecting Advanced-->Advanced settings from the menu. Thats fine for Windows 2003 but in Windows 2008 its missing :-O
However, if you press the Alt key the File menu will appear along with the Advanced option. Isn't it obvious!?
The above didn't work in changing the binding order but after following the link below it finally did work!
This link helped out a TON!
June 27, 2012 at 2:25 pm
Yes 2008 you have to edit the tcpip bindings in the registry
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply