Solved

virtual drives on SAN

Posted on 2014-07-20
1
302 Views
Last Modified: 2014-07-30
I am reviewing some redundancy based checks for a database application (MSSQL) but I wanted to gather your view as to whether these best practices are more geared towards physical servers and opposed virtual servers running on a SAN.

The best practice suggests separating database and log files and backups onto different drives, indicating if one drive dies then the other should be ok and it may not be a disaster.

But for drives on a VM hosted on a SAN - can individual drives on the VM still fail as they could in old physical drives. And by fail I mean can they fail in isolation, or would it be more likely the whole VM would fail as all the "virtual" drives on the VM are on the same hardware (SAN). If virtual drives can still die/fail in isolation even though they arent unique hardware as they would have been on an old physical server, can you give some pointers on how/common reasons they would fail/crash/whatever?
0
Comment
Question by:pma111
1 Comment
 
LVL 117

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE) earned 500 total points
Comment Utility
There was a time that the statement you have made was applicable to Physical Servers and Direct Attached Storage. Because you had limited numbers of disks, and DBAs created Logs on RAID 1 Mirror (2 disks), DB on RAID 1 MIrror (2 disks).

It was done for performance, and disaster recover, because if logs were on separate disk to db, then you could recover transactions, and roll back etc

also logs could fill up the disk, so seperate disk LUNs were created.

However, rollout the SAN, and modern SANs, have many disks and shelves, which are all RAID-RP, RAID 6

and the disk presented for SQL, is either a datastore/VMDK or VHD, which is cut from the SAN on multiple spindles....

BUT, DBAs still like to create seperate disks for DB and Logs. (performance is likely to be the same as a single disk!)

Generally, I think if your SAN failed, ALL disks/LUNs and datastores would be unavailable...

However, there are many different SANs, and it's possible a LUN could fail, and you could be using two different LUNs for your SQL server.

So the example you give is still possible.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
MS SQL export CSV & schedule It 9 40
MS SQL Backup 24 69
svMotion between two different datastore limitation ? 3 34
Test a query 23 11
When we have a dead host and we lose all connections to the ESXi, and we need to find a way to move all VMs from that dead ESXi host.
Exchange server is not supported in any cloud-hosted platform (other than Azure with Azure Premium Storage).
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
This Micro Tutorial steps you through the configuration steps to configure your ESXi host Management Network settings and test the management network, ensure the host is recognized by the DNS Server, configure a new password, and the troubleshooting…

771 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now