Sunday, February 22, 2015

How do you find out SQL Server running on Physical or Virtual Platform ?

Run Select @@version,  Hypervisor means Virtual server


For Physical Server/Platform/Box:
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)   Jun 28 2012 08:36:30   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

For Virtual Server/Platform/Box:
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)  (Hypervisor)

 

1 comment:

  1. http://www.brentozar.com/sql/virtualization-best-practices/

    ReplyDelete