VMWare administrator moved my server without telling me

  • Good Morning,

    How would you be able to determine that the server that houses your SQL Server has been moved (vmotion) by the VMWare administrator?

    Yesterday the VMWare administrator vmotioned the server that housed my SQL Server. The hardware that he moved the server to was having problems.

    Users were complaining that they were having connection issues, but I connected fine to the database database. Using SSMS & profiler, I saw that the database working. I could not find anything in the logs, including the Windows operating system logs.

    The only thing I found was in the SSMS Activity Monitor under the Resource Waits section, the Network I/O - Wait Category had the highest Wait Time.

    To resolve the issue, the VMWare administrator had to move my server back to the original hardware.

    We had database administrators, network administrators, and Windows system administrators all looking for the cause of the issue without finding anything for an hour before the VMWare administrator confessed that he moved the server to different hardware that afternoon.

    Has anyone run into this issue, and is there a way to tell that you have been moved. How would you determine that your server had been moved.

    Anyone's input on this issue is appreciated & thank you in advance.

    Mike

  • You can run a little POSH script like this one every now and then (or on a regular basis)

    http://www.ldap389.info/en/2012/03/22/powershell-vmware-and-physical-windows-server-inventory-license-wmi-cpu-core-count/

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • How is it possible that the VM Admin would move a SQL Server and the SQL Server folks not be aware ahead of time? That's a real problem.

  • sqlgreg (1/9/2013)


    How is it possible that the VM Admin would move a SQL Server and the SQL Server folks not be aware ahead of time? That's a real problem.

    I completely agree with that.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Thanks to everyone who responded. I believe that Mike Hillwig has answered my question in his blog post here:

    http://mikehillwig.com/2013/03/12/knowing-when-a-vm-moved-between-hosts/

  • Mike Hays (8/14/2013)


    Thanks to everyone who responded. I believe that Mike Hillwig has answered my question in his blog post here:

    http://mikehillwig.com/2013/03/12/knowing-when-a-vm-moved-between-hosts/

    Making it easier for others to check out the blog:

    http://mikehillwig.com/2013/03/12/knowing-when-a-vm-moved-between-hosts/

  • Thanks Lynn!!!

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

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