A small but helpful query is this:

select

@@SERVERNAME AS Instance,

serverProperty('ComputerNamePhysicalNetBios') AS PhysicalServer

It tells you the instance name and what PhysicalServer that the node is sitting on. I've worked...