Development environment best practices for large systems

What would be ideal development environment for large systems and multiple developers? Having one production GR and several engineering stations with IDE? A separate development GR with IDE for each developer? Something else?

We are facing serious performance issues with our current setup and would like to know what is the best approach.

  • Are you only using just this single Galaxy all the developers connected to it to develop your system ?

    How many developers do you currently have connected to the system ?

    Are you using the latest SP2023 R2 or an earlier version ?  What abt the SQL Server version and build ( express / standard / enterprise ) ?

  • Correct, there is only one galaxy for all developers. Most of the time, there is at least 5 concurrent development sessions, with that number going up to 8. SP 2023 P03 is in use. As for the SQL server, result of select @@version is as follows:

    Microsoft SQL Server 2019 (RTM-CU16) (KB5011644) - 15.0.4223.1 (X64) Apr 11 2022 16:24:07 Copyright (C) 2019 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2022 Standard 10.0 <X64> (Build 20348: ) (Hypervisor)

  • Perhaps the new P04 could provide some better performance?
    I see this in the the readme file as part of one of the resolved issues.

    IMS 2632194

     

    960333771

    WIth multiple users connected to the Galaxy Repository (GR), checking in objects from the IDE took an unacceptably long time and caused other users' sessions to hang or lose connection to the GR.