March 22, 2012 at 4:21 pm
All,
I am trying to compile a list of everything that needs to be done specifically for a SQL Server (2008) in the P2V process. We have plenty of experience with the people doing other types of P2V here, but not SQL Server, and I can't seem to find any documentation of special things to look for, set, special health checks, etc. Does anyone have this by any chance, or know of any 'gotchas' that I need to look out for?
Thanks,
Adrienne
March 22, 2012 at 4:26 pm
You might want to read this:
http://www.brentozar.com/archive/2008/08/sql-p2v-what-really-killed-the-dinosaurs/
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
March 22, 2012 at 4:32 pm
I did read that, thanks! He basically doesn't seem to have any gotchas at all, or mention benchmarking, or anything... that is the sort of stuff I am looking for! I know that a cold movement is better, and that shutting down all replication, etc., is good, but that is about it.
March 22, 2012 at 4:35 pm
We migrated several SQL servers (2000 and up) via P2V that involved replication and service broker. Doing it cold, when we brought up the Virtual machine we had 0 issues. It was very seamless. End users had no idea it had happened.
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
March 22, 2012 at 4:46 pm
if you P2V the server while its powered on just remember to stop the sql server services and set them to manual to be safe. If you P2V the server with the sql server services running and there is database access in flight you'll end up with the databases being marked suspect on the VM or the P2V will fail due to the differences between the data and log drives (assuming there on separate disks) as they are converted separately in sequence.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply