We're running 2 instances on each node in a cluster (and I wish we weren't). Between trying to balance the disk space (no SAN either) and the memory, its a PITA. They won't give us enough memory to run things the way they should be, so I'm trying to write some procs that will rebalance memory on the fly in the event of a failover. The main thing I need to figure out is how to get the physical server that the instance is running on. So far, all I can get is the virtual server name, which doesn't tell me what I need. Anybody know how to get the actual physical server name? If I can get that, I'm pretty sure I can utilize more than half the memory on each node.