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:ezi...@lifespan.org

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 listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin

Reply via email to