george sibbald (2/14/2011)
does it focus down on individual queries as the cause of high resource usage, show query plans, suggest possible improvements?
No. It's more of a server-wide picture, with occasional deeper insight when certain events hit. As I mentioned in the article, I'm very much looking forward to additional enhancements.
You say servers must be defined by physical name which is obviously an issue with clusters, but the SSC servers being monitored are clustered? Is this a case then of monitoring all the nodes in the cluster but having to know which node is currently active?
I don't know if the SSC servers are clustered or not. Yes, you can put both physical names in, but AFAIK the tool doesn't tell you which node is active.