Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Best practice for lun presentation/carving for SQL instances

Posted on 2011-02-28
6
1,083 Views
Last Modified: 2012-06-21
Hi,

We are about to upgrade our current SQL environment which will utilise our current SAN environment. We currently have two SQL instances, one physical and one virtual (ESX).

I have configured three LUN’s on our SAN which are:

-  VMFS_LUN (ESX Server storage)
-  Data_LUN (SQL data)
-  Logs_LUN (SQL logs)

Below are the two SQL server instance and their disk configurations.

SQL Physical Server
C:  Local disk - OS + App install
D:  Shared storage (Log_LUN)
E:  Shared storage (Data_LUN)

SQL Virtual Server
C:  Shared Storage (VMFS_LUN) - OS + App install
D:  Shared storage (Log_LUN)
E:  Shared storage (Data_LUN)


My question is related to best practice for lun presentation/carving for SQL instances.
Is it better to create a different LUN for each SQL instance I have? For example: Log_Lun1 (SQL Physical Server) &  Log_Lun2 (SQL Virtual Server)

Also on our SQL virtual environment D and E drives, is it better to create these drives as VMFS which point to the Log and Data LUN’s? or should I used the isci initiator in windows?  


Any advice or suggestions will be welcomed!!!!
0
Comment
Question by:cmga
6 Comments
 
LVL 42

Expert Comment

by:paulsolov
ID: 35002869
What are your IOPS requirements, SAN model, and Backup capability?
0
 
LVL 119

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 500 total points
ID: 35002890
Personally I would create, different LUNs for different SQL Instances, for Data DB and Data Logs.

VMFS versus iSCSI initaitor?

How will you backup the SQL servers, if it's all virtual, third party backup tools will back it all up.

If you present an iSCSI LUN via Microsoft Initiator, you'll need another mechansim to back this up, because it's not a virtual presentation (e.g. vmdk), or you could consider an RDM to the virtual machine as well. Remember VMDK on VMFS, give is lots of flexibility, versus the trade off of some performance.

also if you do iSCSI in the virtual machine, the virtual machine CPU is doing the iSCSI work, rather than presenting the LUN to ESX, and formatting the LUN as vmfs, and using a standard VMDK on the LUN.

I would recommend, presenting LUN direct to ESX server.
0
 

Author Comment

by:cmga
ID: 35003190
IOPS Requirments? Still looking at this.

SAN Model? HP LeftHand Networks P4500

Backup Capability? Databases are backups by SQL and we do a file level backup of all the *.bak files on a nightly basis.
There are no requirements for a VCB image backup of the virtual SQL server as yet, but we will configure an image back of the virtual sql server which will exclude d & e drives.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 4

Expert Comment

by:virtualxistance
ID: 35003395
Is the Physical / Virtual SQL instance for redundancy or just 2 seperate Instances?

Unless you are trying to use some sort of an Active Passive SQL setup, with a SQL Cluster / File Cluster  i don't think you'd be able to point to the same LUN from both servers and do a simultaneous RW.

If for seperate instances, I would suggest having 2 different sets of LUNS for the Data and Logs on each server.

Let ESX take care of the LUN than using iscsi initiator in Windows.
0
 
LVL 4

Expert Comment

by:mail2vijay1982
ID: 35017253
The simple answer is you want a config that's balanced and easy to understand without referring to a spreadsheet each time you allocate LUNs. So here's what I've recommended for some of my customers:

RG/LU Carving:

All LU's are the same size. Larger LU's are created by merging multiple LU's together.

Within any raid group, every LU is assigned to the same controller.
RG0/2/4/6/8 -- Even raid groups (RGs) go have all their LU's assigned to CTL 0
RG1/3/5/7/9 -- Odd RGs have all their LU's assigned to CTL 1

A LU can be any four digit number from 0000 to 4095.

First two digits of the LU number matches the RG number, last two digits represent the "slice" within the RG.

So the LU's within RG6 would look like:

0600, 0601, 0602, 0603, ...

You can also make the first ten LU's in a RG small, the rest big, and separate them by gaps in the slice, i.e.: 0600-0612 = 30GB, 0640-0667 = 120GB, ...

This numbering system allows easy space recovery and reallocation when a server is decomissioned.
0
 

Author Closing Comment

by:cmga
ID: 35178122
No all items where answered.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

This article will show you how to create an ISO CD-ROM/DVD-ROM image (*.iso), and MD5 checksum signature, for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5). It's a good idea to compare checksums, because many installations fail because of a corr…
This article outlines why you need to choose a backup solution that protects your entire environment – including your VMware ESXi and Microsoft Hyper-V virtualization hosts – not just your virtual machines.
Teach the user how to use configure the vCenter Server storage filters Open vSphere Web Client:  Navigate to vCenter Server Advanced Settings: Add the four vCenter Server storage filters: Review the advanced settings: Modify the values of the four v…
Teach the user how to use vSphere Update Manager to update the VMware Tools and virtual machine hardware version Open vSphere Client: Review manual processes for updating VMware Tools and virtual hardware versions: Create a new baseline group in vSp…

829 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