perfmon as resource in cluster?

[aspijker]

Hi,

I'm a DBA where my SQL server is running on a clustered environment. We have two nodes and recently I found out that when there is a failover the performance counters (which I'm saving in SQL server) are not saved anymore. A logcal conclusion would be that the performance monitor is not regisered as a resource in the cluster. Now is my conclusion right and is it possible to add the windows perfmon as a cluster resource?

Thanks in advance for your comments.

Regards, Aspijker

 

[xmsre]

As far back as SQL 7.0, you can run perfmon remotely from a host and connect to the virtual server name on the cluster to gather the perfmon counters. There are a few issues specific to specific versions of SQL, however the resolutions are detaild in the MSKB. Try searching the KB for "Cluster SQL Perfmon"