We have a large SQL Server instance, and we are planning to use FILETABLE in one of the new databases. For using FILETABLE, we need to enable FILESTREAM feature at the SQL Server instance level with FILESTREAM access level settings. We are worried if enabling the FILESTREAM option at the server instance level would negatively affect the overall performance of other databases in the instance even though they are not using the FILESTREAM feature.
No, it shouldn't. We have a Filestream enabled Database on our exceptionally heavily used Data Warehouse Server and we've never once seen ANY impact of the DB being FileStream enabled.
Now, what you DO with that Filestreamed files is a totally different matter....