Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 sqliosim test causing SQL Server 2005 64-bit clust

Author  Topic 

imarchenko
Yak Posting Veteran

57 Posts

Posted - 2008-12-11 : 19:39:38
Hello!

We have just configured new Active/Passive SQL Server 2005 64-bit Standard Edition cluster. I have been running sqliosim to test the server and it was consistently causing server restart/fail over to the other node.
The only meaningful messages I found in the logs were:

'SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.
'
'[sqlsrvres]CheckQueryProcessorAlive: sqlexecdirect failed'


We found following link for SQL Server 6.5 (?!!) suggesting changing IsAlive interval:

http://support.microsoft.com/kb/185806

Did anyone experience similar problems? We checked and all drivers/firmare seem to be up to date.

Any advice and greatly appreciated.

Thanks,
Igor
   

- Advertisement -