T-SQL to find whether the SQL server is running on physical or virtual server.

SELECT SERVERPROPERTY(‘computernamephysicalnetbios’) AS ServerName
,Server_type = CASE
WHEN virtual_machine_type = 1
THEN ‘Virtual’
ELSE ‘Physical’
END
FROM sys.dm_os_sys_info