SQL restarts itself

Giganews Newsgroups
Subject: SQL restarts itself
Posted by:  db
Date: Fri, 23 Apr 2010

We have SQL 2008 64-bit running on Windows 2003 R2 64-bit.  It is setup as an
Active/Active cluster.  On the secondary(less used) node, SQL will restart 3
or 4 times a day.  No warnings in the Event Log or SQL log.  In the Event
Log, the message is categorized as a Failover message.  However, it doesn't
fully failover to the other node.  In a couple of minutes, it is back up and
running and everything looks fine.  However, during these two minutes, as you
can imagine, everything goes haywire and support phones start to ringing :)
Here is the error in Event viewer:  CheckQueryProcessorAlive: sqlexecdirect
failed.  Anyone seen this in SQL 2008?

--
DB

Replies