February 9, 2010 at 12:18 pm
Hi, last week we had an incident when suddenly at about 7:23 am when there is no big load on db, the server started to refuse all connections. SQL Error logs showed no error. SQL Agent stopped.
Event viewer showed this error:
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(3)
Event ID:17052
Date:1/30/2010
Time:7:23:18 AM
User:N/A
Computer:BFPDB02B
Description:
[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
it is Microsoft SQL Server 2000 - 8.00.2282 (Intel IA-64) Dec 30 2008 02:10:11 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1) , SP4 installed. Clustered.
thank you in advance for any advice.
February 10, 2010 at 2:42 pm
Is this a clustered instance? Have you checked the following article?
Clustered SQL Server do's, don'ts, and basic warnings
Joie Andrew
"Since 1982"
February 10, 2010 at 3:39 pm
Thank you for your reply, it is clustered, I will read this article and share it with IT who is responsible for all cluster related stuff,
LL
February 10, 2010 at 4:00 pm
If you administer the database on the cluster, then you should be aware of the "cluster stuff" too. There are a lot of caveats with working with SQL on a cluster and you need to understand how SQL and clustering work together and how the apps the databases support are affected as well. That way you know how to handle a situation when the cluster goes down or a failback needs to occur.
Joie Andrew
"Since 1982"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply