Post reply

Virtual or Physical

  • May 13, 2016 at 11:00 am

    #310634

    Hi

    I am looking for a way to determine if the server is Physical or Virtual using SQL Server 2008. Can you please let me know if there any easy way to find out without using xp_readerrorlog? Also this info is available in DMV from SQL 2008 R2. Any help or input will be useful for me.

    Thank you

  • May 13, 2016 at 11:16 am

    #1878983

    there's a DMV with that info:

    select s.virtual_machine_type,

    s.virtual_machine_type_desc

    FROM sys.dm_os_sys_info s

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • May 13, 2016 at 11:21 am

    #1878986

    This works from SQL 2008 R2 onwards. But in SQL 2008 it doesnt work.

  • May 13, 2016 at 12:33 pm

    #1879015

    You can try doing something like this:

    CASE

    WHEN RTrim(@@VERSION) LIKE '%(VM)' + CHAR(10) THEN 'Virtual'

    WHEN RTrim(@@VERSION) LIKE '%(Hypervisor)' + CHAR(10) THEN 'Virtual'

    ELSE 'Physical'

    END AS Machine_Type

    ...but I can't vouch for the reliability of this.

  • May 13, 2016 at 1:10 pm

    #1879031

    Thank you. It works for me.

  • May 15, 2016 at 1:22 pm

    #1879152

    usually the error log will identify virtual machines as the instance starts, look for the hardware info

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply