Sunday, July 26, 2015

MS best practices for filestream and netapp

We are going to take into support SQL Server DB with Filestream feature. There is a page with MS best practices for mount points dedicated for SQL Server Filestream - https://technet.microsoft.com/en-us/library/dd206979(v=sql.105).aspx
Defragmentation and 64KB NTFS clusters from this page are not mandatory if you use Netapp storage for filestream.