June 4, 2008 at 8:52 am
Hi
I am new to this forum. Basically i am a Infrastructure Guy who is managing the Servers (cross pllatforms). I am trying to findout what is the best way to virualize the SQL servers in a performance perspective.
If any one has virtualized the SQL server environment please share the ideas/thought process/bench work which you have done.
Note:- We have tried out with piolt project we are facing lot of performanc e issues.
reg
ananth
June 4, 2008 at 9:04 am
I just read a short blog post that touches on this subject, http://sqlblog.com/blogs/john_paul_cook/archive/2008/06/04/hyper-v-at-teched-questions-and-answers.aspx that might be of some interest to you.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
June 4, 2008 at 9:21 am
You don't want my help. Here's a short[/url] account of all the problems we ran into attempting to virtualize some of our servers.
"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
June 4, 2008 at 9:42 am
We are using VMWare and have had great success virtualizing SQL Servers. We started out with our smaller SQL 2005 servers and are not doing any clustering on them. We are using a SAN backend and it is great to be able to add more disc space when you need it. We have a really good VMWare guy too, so I think that makes a lot of the difference.
June 4, 2008 at 11:11 am
Thanks very much all of you for your inputs/findings.
it will be usfull to restart my road map on SQL P2V
June 4, 2008 at 11:18 am
High DC
What is your Vmware version? is it ESX 3.x?
How many Instances you have on one VM server?
How many processor cores have been allocated for that VM server?
Do you process OLAP Cubes (analysis services) or simple database?
reg
ananth
June 4, 2008 at 1:45 pm
Yes, that is the version we are on.
For the instances, it depends on the databases and load levels, but we don't run any higher than 10-15 instances per system.
We scale processors based on the servers needs, not all of them need 2 processors and you can add or remove processors with VMware. It is really flexible and allows you to better utilize your resources.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply