I'll be going onsite to run some performance tests for a client. They have a Windows Failover Cluster, which has a clustered instance of SQL Server. Let's assume for this post that my client's Windows Failover Cluster has two nodes, as in the image below.
I'll be running a server-side trace (via a tsql script generated from SQL Profiler)--I'm quite comfortable doing this. After I connect to
EkTechready14.Redmond.com\MySqlInstancevia SSMS and start the trace, I am of the opinion that it doesn't matter which node is active when the trace is running. Do you agree?
I'll also be running Perfmon to gather some garden variety stats. Maybe for Perfmon, it does matter which node is active. Should I run Perfmon from the client access point (
EKTechready14.Redmond.com)? Or from the active node (either