March 1, 2011 at 12:55 pm
Has anyone virtualized their SQL Server instances? Do you have any lessons learned to share?
March 1, 2011 at 2:58 pm
Make sure you have beefy machinery. I'd suggest reading up on Brent Ozar's blog because he's posted on virtualization quite a bit.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 1, 2011 at 11:25 pm
Hi,
One lesson we've learned from our virtualization experiments a way back is, that you should never use virtual hard drives for databases. Always access your LUN directly from the guest operating system (VMWare calls this feature a pass-through, I believe) because virtual hard drives can really impact your I/O performance negatively.
Also virtualization will always bring some overhead, that cannot be avoided. However in smaller environments this can be acceptable when compared to benefits.
Br,
Mika
March 2, 2011 at 7:10 am
Thanks. I'll review the blog.
March 2, 2011 at 7:47 am
imMHo the most important statement regarding virtualization by Brent'O that is to be found is :
http://www.theinfoboom.com/articles/virtualizing-databases-too-big-to-fail
It concerns the most forgotten issue with virtualization.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
March 3, 2011 at 6:57 am
We moved two test SQL Servers and one very low utilization and low IO prod SQL Server on VM. Haven't heard of any problems.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply