2012-07-31 07:21 AM - edited 2015-12-18 01:18 AM
Want to start getting some of our SQL server estate away from or current configuration which uses FC attached Luns, SnapDrive and SMSQL.
To use any of the new netapp/vmware technologies to be able to quickly clone test copies of servers etc and look at product such as VMware vCloud Director it looks like having multiple LUNS on multiple volumes aren't really a good configuration.
Is there anything around or on the horizon from Netapp that allows you to do application consitent snapshots for SQL servers running entirely on .VMDK drives on NFS datastores.
I know that you can now see and work with .vmdk drives in snapdrive so wondering if this will be moving up to SMSQL?
2012-07-31 07:32 AM
With SMSQL 5.1 this functionality can be provided:
SnapManager 5.1 for Microsoft SQL Server introduces the following new features:
2012-07-31 07:54 AM
That is useful to know and looking through that guide though looking at the Database storage designs on page 74 all the recommended supported configs show vol to lun to SQL user DB's type scenarios.
I am familiar with these from my current setup but wanted to know if there is anything out there which states what can be done with vmware nfs setups using entirley vmdk based installations?
We currently use separate volumes\luns for systemdbs, sqldata, sqllogs, snapinfo and tempdb, if i wanted to move these to NFS would they need to all be on separate volumes\nfs mounts in the same sort of configuration?
2012-07-31 08:39 AM
Sorry there is a better TR which writes about SQL on VMDK...
See page 36 ff.
Additionally the Install Guide for SMSQL 5.1 in Chapter 12 has even more information about this.