Solved

virtual drives on SAN

Posted on 2014-07-20
1
314 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 119

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 500 total points
ID: 40207777
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Each year, investment in cloud platforms grows more than 20% (https://www.immun.io/hubfs/Immunio_2016/Content/Marketing/Cloud-Security-Report-2016.pdf?submissionGuid=a8d80a00-6fee-4b85-81db-a4e28f681762) as an increasing number of companies begin to…
Giving access to ESXi shell console is always an issue for IT departments to other Teams, or Projects. We need to find a way so that teams can use ESXTOP for their POCs, or tests without giving them the access to ESXi host shell console with a root …
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

856 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