My organization is considering FileStream/FileTable for managing documents such as PDF, image, video, etc. Sizes of files range from sub-MB to 50+ MB. There are 1MM+ files that need to be managed.
Most files are currently in network folders. This makes finding files by subject-matter/content difficult but we have a way of associating metadata related to the file once it hits the database. This allows us to search for documents easily instead of relying on file naming conventions.
I read how SQL Server must have storage setup locally to the server but a SAN may be used. I am not a systems person and don't know my SAN from a NAS.
Does anyone have experience setting up FileStream/FileTable using a SAN for the storage location? Any advice or words of caution?
Thank you in advance for your time!