January 9, 2013 at 9:01 am
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
January 9, 2013 at 9:37 am
You can run a little POSH script like this one every now and then (or on a regular basis)
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
January 9, 2013 at 9:38 am
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.
January 9, 2013 at 9:40 am
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
August 14, 2013 at 8:29 am
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/
August 14, 2013 at 11:16 am
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/
August 14, 2013 at 11:17 am
Thanks Lynn!!!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply