Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chris_cs
Posting Yak Master
223 Posts |
 Posted - 2011-02-23 : 09:06:19
|
| Hi guys,I know this is probably a "how long is a piece of string" type question, but I was hoping I could canvas people's opinion on this and see what experiences you have had.My boss would like to upgrade from 2005 to 2008 in a virtual environment (or at least that's the plan at the moment) but I have some doubts due to performance etc. I expect SQL Server would always perform better on its own physical box, but could we see that much of a decrease in performance?Is there anything I should be considering with SQL Server in particular when virtualising? And has anyone experienced any issues with VMotion? I've heard this can be a potential issue due to memory etc...Any thoughts/hints etc would be much appreciated! |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2011-02-23 : 13:51:45
|
| what is your/your boss's reason for virtualization? condolidatation? better manageability? better/different HA needs?there are some excellent whitepapers on virtualization you should read before proceeding: http://www.microsoft.com/sqlserver/2008/en/us/virtualization.aspxDinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2011-02-23 : 15:37:38
|
| Consolidation is the main reason. I'll certainly look into the white papers in the link you suggested, I just thought it would be good to get the opinion of people who have actually done it.I might actually be worrying about nothing, although I've learnt that it's normally best to be worried! My plan at the moment is to load test the new virtual machines once they are in place to compare the performance. Would the best way of doing this be to use a trace an replay activity on the virtual box?Thanks for your help |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2011-02-23 : 17:42:45
|
| yes.. if you want to measure the performance in the VM, you can run the baseline against the workload on the physical box and replay it in the VM and compare.. however, there are several aspects you should consider before consolidation. The WPs are give you lots of good info to think about before making the move..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
Should we virtualise?