We have a cluster set up at my office ( Active/Active ) that has been
pitched as some prime real-estate, apparently, as the best place in the
office for a database. Now it looks like one of my nodes is overrun with
databases! I'd like to set up some traces in profiler or performance
monitor to gather some stats in case we start to experience some degredation
in performance. I want to be able to point to some numbers to explain to my
boss why we shouldn't put so many databases on one node. Any suggestions
on what are some good counters to turn on? I'm thinking I should monitor
I/O wait and paging at the very least. I've also heard someone mention to
monitor page life expectancy, but I don't know much about this one.
TW