May 09 2018 02:45 AM
By installing a SharePoint 2016 farm, is it possible to install the database in a dbserver used by other business applications?
Can there be performance problems if the database does not reside in a db server exclusively dedicated to the SharePoint 2016 farm?
May 09 2018 09:00 AM
Yes, you can, but it is strongly not recommended. The instance used by SharePoint must have MAXDOP = 1, which can severly hamper performance of your other databases.
You can use multiple instances on a single SQL Server, but you must appropriately balance memory usage, and closely monitor CPU usage and Disk I/O (if sharing the same disk).
May 09 2018 09:24 AM