To add to what he said, you probably do not want to run SQL over CIFS unless you are using SMB 3.0 (Windows 2012)

*Jeremy Page*|Senior Technical Architect|*Gilbarco Veeder-Root, A Danaher Company* *Office:*336-547-5399|*Cell:*336-601-7274|*24x7 Emergency:*336-430-8151 On 08/21/2013 11:08 AM, Mike Horwath wrote:

On Aug 21, 2013, at 9:46 AM, Joseph Bishop jbishop@west.net wrote:

...

Hello Toasters,

We have a new NetApp and are going to migrate our SQL Servers onto it.

For many reasons, I would like to avoid LUN provisioning and would prefer NFS or CIFS.

Can I get feedback on which works better in practice?

Any hypervisor in operation?

If not then CIFS is your obvious choice as NFS, while capable for many things, won't have the same integration with SQL Server as CIFS would.

If hypervisor, and hypervisor is VMware, then NFS to store your VMDKs on.

If it is Hyper-V then CIFS.

best of luck! _______________________________________________ Toasters mailing list Toasters@teaparty.net http://www.teaparty.net/mailman/listinfo/toasters

Please be advised that this email may contain confidential information. If you are not the intended recipient, please notify us by email by replying to the sender and delete this message. The sender disclaims that the content of this email constitutes an offer to enter into, or the acceptance of, any agreement; provided that the foregoing does not invalidate the binding effect of any digital or other electronic reproduction of a manual signature that is included in any attachment.