Link to home
Start Free TrialLog in
Avatar of pchettri
pchettri

asked on

SQL 2014 installation

When installing SQL 2014 it gives option to choose drive location for database, log and backup. On my Vmware environment I have fast ISCSI drive which I will be mapping from two different LUN and volume for database and log.
Also, I have a old re-purposed server with direct attached storage and with a network through put of 3 GB LACP aggregation and it has CentOS that publishes the volume to my vmware and I use that drive only for backup.
Would it be recommended to use slower volume for SQL database backup location when it prompts during the installation that way my backup location is completely isolated from production ISCSI SAN instead it will be using NFS based SAN from old server with DAS. Would there be any performance penalty for choosing "relatively" lower performance drive during the installation. However, if there is performance penalty could it be changed after installation or after bringing server to production or there will be lot of downtime if such is required?
Avatar of Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Flag of United Kingdom of Great Britain and Northern Ireland image

Fast datastore for the virtual machine Database and Log virtual machine disks are recommended. So you fast iSCSI drive seems ideal, but do you know the IOPS those datastores?

Your slower DAS Centos NFS datastore seems okay for Backup, you can change these after installation, or even move the virtual disks between datastores. (which would be far easier, the OS and SQL installaton don't know where the virutal disks are hosted)

Have you compared and tested by NFS and iSCSI datastores or performance ?
Avatar of pchettri
pchettri

ASKER

My ISCSI data stores are two 10 G NIC with MTU 9000 with fail over and on netapps end lacp is enabled with 2 combined interface on each filer connected to two switches with twinex cable for redundancy and better through put. I have around 12 VMs hosted out which Exchange and new SQL would be IO intensive.
For NFS it uses LACP of three 1 G network from switch to storage server and ESX hosts.

Changing and choosing different drive would completely needs to be done from SQL not from VMware or storage. SQL offers option to choose database, log and backup. The backup it offer is for default SQL based backup location apart from scheduled backup which I would be provisioning after SQL is brought online on production.

If the default backup folder selected during the installation impacts to overall performanace of server I/O then I would need to point that to one of ISCSI drive instead of NFS. If it works fine then I can save the space on ISCSI for future deployment.
What is the SQL database size ?

It should not impact overall performance, but you can migrate virtual machine disks between datastores, that's the advantage of having multiple datastores connected to a single host.

a faster backup LUN, will result in a faster backup, SQL Online Backups are designed to run with active users, so large backups can take a while.

e.g. you can have

virtual machine disk 1 - NetApp iSCSI - Database Disk (OS disk e.g. D:)
virtual machine disk 2 - NetApp iSCSI - Log Disk (OS disk e.g. E:)
virtual machine disk 2 - NFS - Backup (OS Disk e.g. F)

but those virtual machine disks can be on any datastore, and moved between datastores.

and if you have the correct licenses, SQL VM, will not even notice! in real time, with no downtime. e.g. Storage vMotion.

(an aside - NetApp also recommend NFS, as it's lower overhead than iSCSI, and NetApp filers' were originally developed around NFS, iSCSI is another layer ontop.

We stopped using iSCSI and migrated to NFS on NetApp many years ago.)
I remember your suggestion about NFS data store on previous post but I have all my VMs already running on ISCSI initiated used on ESX and I only have 1.6 tb free disk space left on each filer for provisioning NFS and that space wont be adequate for moving Vms which have already take 50 % of provisioned ISCSI storage volumes from netapps. I have to continue using ISCSI until we decide to purchase additional filer or find a way to extend storage over existing FAS2554.
About Vmotion I have essentials license that allows datastore Vmotion in shutdown state. Would it be possible to do vmotion from NFS to ISCSI volumes?
ASKER CERTIFIED SOLUTION
Avatar of Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial