We have infrasctructure folks that setup and configure hardware when we need a new SQL Server for something.
Once the server team turns it over to us, they provide me a name and say "Here's your server name."
In turn, I use RDC to connect up to that machine and begin installing the SQL Server instance etc.
But once I get onto it, is there a way that I can easily tell if I've been provided a physical server or a VM shared amongst 5 other SQL Server instances?
We're seeing some strange stuff on one of our servers, and if I didn't know better, then I'd swear that the symptoms are more like those of a loaded-down VM.
Is there perhaps a DMV query that might yield this information?
Thanks for your thoughts.