We are planning to create a global portfolio that includes all SonarQube projects across the organization and would like clarification on the following:
Is there any maximum limit on the number of projects in a portfolio?
Does portfolio size impact:
Portfolio recomputation
Background task execution
Executive report (PDF/email) generation
Please confirm any limitations or constraints related to large/global portfolios.
In SonarQube Server, there’s not a hard limit on the number of projects in a portfolio. The larger your portfolio, the bigger an impact it can have on performance, although I don’t have any specific benchmark at hand to give you.
The main piece of advice I can give you is to try it yourself and to tweak when portfolios are recalculated using Administration > Configuration > General Settings > Governance > Recalculation > Portfolio Calculation Hours, so that recomputation runs only at specific hours (for example, at night) instead of on every project analysis. Moreover, you can also control the frequency of executive reports at Portfolio settings > Executive report. You will need to find a sweet spot for these configurations that fulfill your needs but that don’t overload your instance.