Hi, What are the performance counters and errors which can be monitored to know whether a node is working perfectly in clustered envoirment. For both Active/Active and Active/Passive Cluster
http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp http://www.sql-server-performance.com/sql_server_performance_audit.asp http://www.sql-server-performance.com/best_sql_server_performance_tips.asp http://www.support.microsoft.com/?id=q224587 HTH 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.
Hw Will I know that one node is down and other node has taken the resources perfectly to work.Which errors should I observe for this.
I don't see there are any specific counters in the cluster, as per the SQL is concerned it is an usual installation. Follow the links above for the counters to monitor. Event viewer, SQL Server error log is the best bet to look for any warnings or issues. http://www.sql-server-performance.com/real_life_dba_cluster_failover.asp 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.
