SQL Server Performance Forum – Threads Archive

Problem with clusters

Hello everyone We have 4 production servers that are clustered, all Active/Passive. We ahave been having a strange problem from few days. There is one particular table thats troubling the whole server,when any operations(even select) are done on it, failover is occuring. We have tried to rebuils the database, but the same thing is happening once again. What could be the trouble? Any solutions? Thanks
Satya

The trouble was particularly happening because of one database to be precise. Any backup, restore, running triggers, anything of that sort the cluster is failing over back and forth.

First check the SQL error logs and Event logs as well as cluster log for any errors…
Run the check table against problematic table after restoring the db on to any other server for corruption… What happens if you run…"Select top 1 * from problemtable"…
Does it cause failover? Try diabling the parallalism and see what happens…
In sql 7 parallalism caused one of cluster server to failover many times…
Mohammed U.

You need to be more clear by looking at Clustering logs and event viewer logs. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

Also check if there is any hardware problem to the server. It may be a case that the primary server is failing back because them

Hi Satya Check the following :: 1> ErrorLogs for any Access Violations, Assertions and/or any stack dumps that are coming up
2> Application and System Event Logs on Both Node 1 & 2 for any hardware errors.
3> The Cluster.log for any errors on the Resources
4> Check the LOG Directory for any SQL Server Dumps (*.dmp and *.mdmp) If you do see the above like any Access Violations and/or any dumps contact MS Support. MS Support can find if there is any fix to those dumps. Check for Hardware errors as well. Also does the Table in Question reference any Trigers which call Extended Stored Procs or any COM objects. Another important things check for Dependencies on the Cluster as well. Check for any
1> 3rd Party DLLs loaded on SQL Server Process Space (You can find this by using Process Explorer on Windows systems)
2> Any Filter Drivers which needs to be updated. Use Fltmc command to find out. In short Download MPS Reports from Microsoft support Site and check the above files on the cabinet files. Thanks
Sumit Sarkar Sumit sarkar

Thanks Sumit There was an OS config problem. Issue resolved. The OS team took care of it Thanks
Satya

Satya, If possible…Can you please post some more details about your solution to your problem<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> MohammedU. Moderator SQL-Server-Performance.com

MOhammed I am a begginer in clustering and haven’t setup the clusters by myself. I had very little info in a very brief email from the OS team that the problem got solved and mentioned that it was due to config problem. Thanks
Satya

Not a problem… take it easy… MohammedU.
Moderator
SQL-Server-Performance.com

]]>