question

KummariRani-8976 avatar image
0 Votes"
KummariRani-8976 asked ChelseaWu-MSFT commented

Sharepoint on-prem SQL server for other purposes

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?




office-sharepoint-server-administration
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

trevorseward avatar image
0 Votes"
trevorseward answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ChelseaWu-MSFT avatar image
0 Votes"
ChelseaWu-MSFT answered ChelseaWu-MSFT commented

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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @KummariRani-8976 , do you have any progress on this thread? Please feel free to let us know if you need further assistance.

0 Votes 0 ·

Hi @KummariRani-8976 , I’m checking on how things are going on with this thread.
If you find an Answer helpful, please remember to accept it as answer. It will help others who meet similar questions in this forum. Thank you for your understanding.

0 Votes 0 ·