Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

virtual drives on SAN

Posted on 2014-07-20
1
Medium Priority
?
334 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 125

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 2000 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
It’s time for spooky stories and consuming way too much sugar, including the many treats we’ve whipped for you in the world of tech. Check it out!
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.
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…

581 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