VMware Configuration Help Needed

Posted on 2008-11-07
Medium Priority
Last Modified: 2012-06-21

This is my first post, thanks in advance for your help and input.  I am new to Virtualization, all advice would be greatly appreciated.

I have a Dell PE 2850 that I will using in a production environment that will be used as the failover box for IIS and a SQL DB.  My plan is to utilize ESXi 3.5 and run two virtual instances:
1.  Server 2005 Standard (32-bit) w/SQL Server 2005 Standard
2.  Server 2005 Standard (32-bit) (running IIS)

Dell PE 2850 Specs:
2 x Intel Xeon 3.60GHz CPU
8GB Memory
6 x 146GB HD, 10K SCSI

Currently, I have RAID configured for 3 RAID 1 drives.  I am thinking of the following for each HD:
HD1 = ESXi Host and SQL DB (one small DB)
HD2 = Server 2003 w/SQL
HD3 = Server 2003 /IIS (one site)

The questions I have are:
1.  For a failover box, does the above configuration sound fine?
2.  When installing the OS on the virtual boxes, what specs should I use: (for both the SQL and IIS box)
-Memory allocation?
-Number of virtual CPUs?
-Hard Drive size?
3. When another virtual Hard Drive is created on HD1 for the Database, how do I get Windows Server to recognize this drive?
4. Is it necessary or best practice to have the DB on a separate HD from the OS?

Please list any other thoughts or concerns you may have.

Thanks again,

Question by:Samster80
  • 5
  • 5

Expert Comment

ID: 22911571
If i were you I would run Server 2003 without VMWare and operate IIS and SQL Server on the 2850. Without any virtualization.

Use Disk 1 for OS and rest for DB


Author Comment

ID: 22912798
My DBA is strongly against going this route for security purposes and would like to see both IIS and SQL on separate boxes.  


Expert Comment

ID: 22913505
You have two physical boxes I believe that you're trying to fail over onto 2 virtual boxes?
If you had a VM + 2 servers setup already (your would just have to duplicate what was done).

-> Dedicate the Physical Disks to the SQL VM, increase spindle speed by doing RAID 10 accross 4 drives)

-> Allocated a Virtual Disk of Proper Size to the IIS VM with a Separate VM Disk for IIS Logs.
Use 3.5GB or ram each.
Then again I don't exactly know how much I/O does your production IIS server do aside from network, and how many assemblies it reloads from disk and keeps in cache.

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments


Expert Comment

ID: 22913511
That is if you are trying to setup a fail-over for two real servers.

Author Comment

ID: 22913615
Sorry, I should have added this to my first post.  

Yes, I have two physical servers; one running IIS and the other SQL.  The PE 2850 box will be used for failover for both physical servers.

I've added one virtual instance to ESXi, the SQL box.  Now, when I go into the VI Client and add another Virtual Hard Disk, it shows up on the OS device manager but I'm unable to access the drive, meaning its not under the "Hard Disk Drives".  How do I access and use that Virtual Disk from Server 2003?


Author Comment

ID: 22913756
Thanks for your input, I was able to configure the virtual disks and add them on the OS side.  So thats taken care of.

The only thing left on my side is to confirm your suggestion about RAID.

So, beings how this box will be used as a failover box, is their a problem with my design?
HD1 = Vdisk1: ESXi Host  |  Vdisk2: SQL DB
HD2 = Vdisk1: Server 2003 w/SQL
HD3 = Vdisk1: Server 2003 (IIS)

If I understand correctly, you're suggesting:
HD1 = (RAID1; 2 drives) Vdisk1: ESXi Host  |  Vdisk2: Server 2003 (IIS)  |  Vdisk3: IIS logs
HD2 = (RAID 10; 4 drives) Vdisk1: Server 2003 w/SQL  |  Vdisk2: SQL DB

Is this correct?  If so, what are the pluses and minuses of going this route?

Thanks again for your help,

Accepted Solution

DJDecay earned 1500 total points
ID: 22914239
The only reason why I suggested going this route is that I believe your servers are BUSY, so during a fail over that load will transfer to the third server VMWARE (IIS/SQL) both.

It is not typical of IIS hitting the disk harshly  -  if its serving up some small amounts of static content and an ASP/C# application only IIS is smart enough to cache those.

It is however typical of a a database hitting the disk harshly.

Unless IIS is used to stream huge blocks of binary content such as audio or video, IIS will not
need high speed disks. While  the SQL server that will hold transactions will.


But before you do anything. Can you run perfmon an log a a couple of values of interest over a busy period on the two live servers before you make your setup conclusion

See how many connections IIS is serving, is it equal to the SQL connections. How many transacton per minute and disk queues on both.

Log them to a file with 5 minute intervals. Then have a think about what resources will be a bottle neck on what in the current application state.

I gather you're using only one server and vmware due to physical space constraints or power issues.

Expert Comment

ID: 22914240
Most importantly is IIS serving out a vast amount of Images, Audio Files, Video.


Author Comment

ID: 22923024
Our site is really pretty basic and does not do images, audio or video files.  I looked over my notes from the other two physical Dell servers to see what RAID they are running.  

The DB server is a Dell PE2950 with 4 HD.  
73 GB 15K x 2 = HD1 at RAID 1 for the OS/SQL
146GB 10K x 2 = HD2 at RAID 1 for the DB

The ISS server is a Dell PE 1950 with 2 HD.
36GB 15K x 2 = HD1 at RAID 1 for OS and Site

Going off the specs of the current production servers, I think that RAID one will work fine for our current needs.  I should have looked at the current production servers earlier to confirm their configuration.  

I appreciate your help on this.


Author Closing Comment

ID: 31514621
Thanks for your help with this.  


Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
In this article, I show you step by step with screenshots to assist you - HOW TO: Deploy and Install the VMware vCenter Server Appliance 6.5 (VCSA 6.5), with some helpful tips along the way.
This video shows you how to use a vSphere client to connect to your ESX host as the root user. Demonstrates the basic connection of bypassing certification set up. Demonstrates how to access the traditional view to begin managing your virtual mac…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question