How do you do....it? Thread, Vmdk's or iscsi For SQL db and exchange db in Technical; What best to use for SQL db and exchange db, vmdk's or iscsi targets?
21st April 2011, 09:20 AM #1
Vmdk's or iscsi For SQL db and exchange db
What best to use for SQL db and exchange db, vmdk's or iscsi targets?
21st April 2011, 09:42 AM #2
A few years ago, when harddrives were a bit smaller, best practice used to be to simply assign your database an entire, raw harddrive (or RAID array) for it to use as it saw fit. The idea was that it would bypass any file system overhead and be able to write data directly to the harddrive, arranging disk reads and writes in the most efficient way. These days, an SQL database tends to be just a large file on an existing file system as most databases don't take up the disk space to fill an entire drive or RAID array. However, disk space these days is as cheap as it's ever been, so you'd probably still get best performance if you assign your database a whole block device - a harddrive, RAID array, or, in your case, probably a whole RAID array exported as an iSCISI target from your SAN.
Originally Posted by ful56_uk
21st April 2011, 10:05 AM #3
How busy is your SQL / Exchange box?
How fast is your SAN?
I've got my SQL and Exchange boxes running as normal vmdks... performance is just as good, if not better, than when they were physical boxes.
26th April 2011, 05:53 AM #4
- Rep Power
We have just about everything virtualized now utilizing our iSCSI SAN for storage.
We use a seperate virtual disk for EACH of the following on our SQL servers: OS, databases, logs and backups.
For exchange we use a seperate virtual disk for EACH of the following: OS, Logs, Databases.
The virtual disks are created on several different LUNs which are RAIDed to specific RAIDs depending on their purpose.
26th April 2011, 09:30 AM #5
I think I'm going with vmdks when we do our virtual migration, splitting the data onto a separate vmdk from the OS drive (pretty much same as you would physically, just replace drives with virtual disks )
Will also make it easier to back up as Veeam can just lift the vmdks and whack them onto our backup target server.
Last edited by gshaw; 26th April 2011 at 09:33 AM.
By bodminman in forum How do you do....it?
Last Post: 24th January 2011, 02:55 PM
By kennysarmy in forum Windows
Last Post: 3rd November 2010, 11:52 AM
By albertwt in forum Thin Client and Virtual Machines
Last Post: 12th May 2010, 08:43 AM
By m1ddy in forum Thin Client and Virtual Machines
Last Post: 9th November 2009, 02:55 PM
By DAckroyd in forum Thin Client and Virtual Machines
Last Post: 6th November 2009, 10:33 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)