SQL Server optimization for GR node

I believe you are asking this question in reference to the other question in the following link ?

https://softwareforums.aveva.com/heroes-hq/f/aveva-system-platform-and-omi/82467/development-environment-best-practices-for-large-systems

The articles you have found are basically guidelines how how to configure and optimize SQL Server for the use of Application Server.  They are not a be-all-and-end-all of the settings of SQL Server.  The optimization of SQL Server should be treated like a feedback loop.  It depends on how much your system is currently being used and the loading and adjusted accordingly.  In addition,  what is contained within the Galaxy DB also impacts the performance of the SQL Server.

With that said,  those articles need to be updated with the latest SQL Server versions supported by the latest System Platform version.

There are various factors that may impede the performance of the SQL Server and a review of your system will provide valuable insight as to how best to improve it based on overviewing the entire system.  Please reach out to me here via private messaging to have a further discussion.

I believe you are asking this question in reference to the other question in the following link ?

https://softwareforums.aveva.com/heroes-hq/f/aveva-system-platform-and-omi/82467/development-environment-best-practices-for-large-systems

The articles you have found are basically guidelines how how to configure and optimize SQL Server for the use of Application Server.  They are not a be-all-and-end-all of the settings of SQL Server.  The optimization of SQL Server should be treated like a feedback loop.  It depends on how much your system is currently being used and the loading and adjusted accordingly.  In addition,  what is contained within the Galaxy DB also impacts the performance of the SQL Server.

With that said,  those articles need to be updated with the latest SQL Server versions supported by the latest System Platform version.

There are various factors that may impede the performance of the SQL Server and a review of your system will provide valuable insight as to how best to improve it based on overviewing the entire system.  Please reach out to me here via private messaging to have a further discussion.