SQL Backup, Anti-Virus dat update or Scan initiation? On Fri, Feb 18, 2011 at 9:29 AM, Miller Bonnie L. < [email protected]> wrote:
> Any scheduled tasks in Windows or within SQL? Or, a task running against > SQL (maybe check other servers or workstations that reference the cluster > for their DBs for scheduled tasks). Could also fire up a performance and > netmon capture during the timeframe to see if anything jumps out at you. > > > > *From:* Ziots, Edward [mailto:[email protected]] > *Sent:* Friday, February 18, 2011 5:49 AM > > *To:* NT System Admin Issues > *Subject:* Sounding board on issue we are seeing with a Windows 2003 > Cluster with SQL 2005 > > > > 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 > ~ 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
