Stupid question/suggestion: Have you tried taking the passive node offline to see if the database disconnect still occurs?
Changing switches, as you mentioned would be my next, saner, suggestion. - WJR On Fri, Feb 18, 2011 at 07:48, Ziots, Edward <[email protected]> wrote: > I have a two node X64bit Windows 2003 SP2 enterprise edition cluster running > SQL 2005 Standard Edition 64bit. > > > > What I am seeing is event ID’s 1123, 1124 in the event logs on each Cluster > Node, and we are getting complaints of disconnects from the database. > > > > We are seeing it happen around 5:50-6:00pm each night. ( shows in the > cluster log and we seen it via pings) > > > > 1) We have eliminated the backup of the server, which happens at 3:30am > in the morning ( via Legato) > > 2) I have gone through with Microsoft Support the entire KB 892422. > Which covers these errors. > > 3) I have switched out the cables to the public and the private NIC’s > with no change in issues. > > 4) RSS/TCP Chimney are disabled in the registry and on the NIC’s on > each node. > > 5) NIC Drivers are the latest from HP Site ( NC373i) and EMC Powerpath > software 5.3 SP1 for the SAN disk on each node. > > > > Basically we are pinging the Owning Node server from our workstations and we > loose about 5-10 pings during this time, on both the primary and the > secondary nodes of the cluster. ( both are into the same Cisco Switch 45xx) > > > > We also was pinging each of the servers from each other ( both on the same > switch/VLAN) and we also saw the ping loss at the same time. > > > > Only idea I had is to move the public NIC’s to another switch to eliminate > the switch as the point of contention, or get new hardware and migrate the > databases off this cluster and decommission it. > > > > I checked other cluster nodes connected to these switches ( 32bit) and we > don’t see this problem. > > > > Anything I might be missing or overlooked? Questions, or bouncing some ideas > off the wall is appreciated… > > > > Z > > > > Edward E. Ziots > > CISSP, Network +, Security + > > Network Engineer > > Lifespan Organization > > Email:[email protected] > > Cell:401-639-3505 > > > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to [email protected] > with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
