Sharepoint on-prem SQL server for other purposes

Kummari, Rani 66 Reputation points
2021-03-17T18:27:24.037+00:00

Hello,
We have sharepoint 2019 on-prem environment with SQL server and 4 front end server with min-role architecture.
We also have our inhouse application environment with SQL server and a front-end server for any advanced .NET applications.
So, we are I the process of upgrading our .NET application environment and considering the following options. Not sure if they are recommended by Microsoft.

  1. Create a new instance of the sharepoint 2019 SQL server and use it for the .NET application database.
  2. Use one of the front-end servers for hosting .NET applications.

Is it okay to use sharepoint servers for other use by creating new instances of those servers? or those servers should be dedicated to sharepoint databases/applications?

SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,893 questions
0 comments No comments
{count} votes

Accepted answer
  1. Trevor Seward 11,696 Reputation points
    2021-03-17T19:07:36.427+00:00

    We can't fully answer that question as it would depend on the usage of the farm and your custom .NET application. However, it is non-optimal. SQL hosting SharePoint databases requires MAXDOP of 1 which eliminates parallelization of queries. In addition, you're introducing additional memory pressure.

    Deploying a secondary non-SharePoint web site also has the potential to impact SharePoint performance, but more importantly security. I would be concerned about a custom developed web site being deployed to the same server hosting SharePoint.

    With all that said, you can absolutely do it, but think about the potential performance and security impact.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. ChelseaWu-MSFT 6,316 Reputation points
    2021-03-18T06:36:02.47+00:00

    In addition to Trevor’s Answer, you can refer to this document for what is recommended or required for database server’s configuration: Best practices for SQL Server in a SharePoint Server farm.

    Microsoft will not have this recommendation in written since this is not SharePoint related configuration. As long as you meet all requirements for the SharePoint farm, you can always do that.
    But as Trevor suggested, it is all about performance, so it will not be the recommended practice to use SharePoint servers for other purposes.


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    **Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. **