Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

2 node failover cluster, SQL and DTC rescources lye on seperate nodes Expand / Collapse
Author
Message
Posted Thursday, September 13, 2012 12:28 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 1:08 PM
Points: 88, Visits: 565
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
Post #1358779
Posted Friday, September 14, 2012 2:04 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 6,752, Visits: 14,400
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"
Post #1359102
Posted Friday, September 14, 2012 12:05 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 1:08 PM
Points: 88, Visits: 565
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?
Post #1359542
Posted Monday, September 17, 2012 2:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 6,752, Visits: 14,400
Windows 2003 or Windows 2008 cluster?

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1360027
Posted Monday, September 17, 2012 9:29 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 1:08 PM
Points: 88, Visits: 565
Windows 2008
Post #1360281
Posted Tuesday, September 18, 2012 5:24 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 6,752, Visits: 14,400
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"
Post #1360697
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse