SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


2 node failover cluster, SQL and DTC rescources lye on seperate nodes


2 node failover cluster, SQL and DTC rescources lye on seperate nodes

Author
Message
alanspeckman
alanspeckman
Right there with Babe
Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)

Group: General Forum Members
Points: 756 Visits: 768
If we have 2 resource groups

1. MS-DTC
2. SQL Server

And the MSDTC resources lyes on Node A, and the SQL Server resources(disks, IP, SQL Server, Agent) lye on Node B, would this be a possible cause for users not being able to connect to SQL Server?

Also, If we have 2 web servers load balances, but Server C is 6 hours behind Server D, would this cause issues with users trying to connect to the application, or cause issues with the application trying to connect to the database?

Thank you

Alan
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)

Group: General Forum Members
Points: 51054 Visits: 17653
alanspeckman (9/13/2012)
If we have 2 resource groups

1. MS-DTC
2. SQL Server

And the MSDTC resources lyes on Node A, and the SQL Server resources(disks, IP, SQL Server, Agent) lye on Node B, would this be a possible cause for users not being able to connect to SQL Server?

No, what errors are your users getting



alanspeckman (9/13/2012)
Also, If we have 2 web servers load balances, but Server C is 6 hours behind Server D, would this cause issues with users trying to connect to the application, or cause issues with the application trying to connect to the database?

Thank you

Alan

Are the servers in different time zones?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
alanspeckman
alanspeckman
Right there with Babe
Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)

Group: General Forum Members
Points: 756 Visits: 768
They were not errors really, just intermittent connections issues with getting to 1 server of the 2 load balanced web servers.

I can't RDP into those servers, so I cannot see specific errors.

But the thinking of the SA, at the time, was that since the cluster resources were split between 2 nodes, that was causing the problem. So, she failed over DTC and that made SQL services restart.

Why would SQL Server restart when DTC is failed over, especially when DTC isn't even used according to transaction statistics in the Clustered DTCs folder under Component Services?

Both web servers are on the same timezone. Same with my SQL Servers

I suspect the problem was that one node of the load balanced web servers had the wrong time, off by something like 6 hours, from the 2nd server, where connections were still happening. This would cause intermittent connection problems to the actual application.

Is there any truth to that?
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)

Group: General Forum Members
Points: 51054 Visits: 17653
Windows 2003 or Windows 2008 cluster?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
alanspeckman
alanspeckman
Right there with Babe
Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)

Group: General Forum Members
Points: 756 Visits: 768
Windows 2008
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)

Group: General Forum Members
Points: 51054 Visits: 17653
alanspeckman (9/14/2012)
Why would SQL Server restart when DTC is failed over, especially when DTC isn't even used according to transaction statistics in the Clustered DTCs folder under Component Services?

Service dependencies would be the only logical conclusion

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search