I have created SonarQube schema based on my understanding and consolidated some of the Performance scaling parameters (for .NET) in a form of excel, and it would be nice to see SQ PM to follow up on that and to use their creativity to create some Performance scaling chart with respect to Predicted|Calculated|Observed processing time and AVG cost of running (1) SQ Scanner (Build Wrapper) and (2) SQ JVM Server and (3) SQ DB, in an average Cloud hosting environment.
I haven’t used SQ yet but I’m planning to do so in Azure in the near future. Any correction or feedback for the below Schema or Performance scaling parameters from the Community is welcomed, and I believe you are free to adjust and use it for your own presentation.
"Cloud SQ_VM RAM (Pay as you go) (G)": 4,8,14
"Cloud SQ_VM CPU/Cores(Pay as you go) (#)": 2,4,8
"Cloud SQ_VM Temporary Storage (Pay as you go) (G)": 20,40,605
"Cloud SQ_VM instance type (Azure specific) (text/note)": A2 v2,A4 v2,A4
"Cloud SQ_VM instance price (Pay as you go) AVG per month ($)": 100,200,500
"Cloud SQ_VM CPU Cores AVG allocated (%)": 25,25,25
"SQ_JVM_Web memory (Java Heap Size) $YOUR_SONARQUBE_INSTALL_DIR/conf/sonar.properties (sonar.web.javaOpts) -Xmx(maximum) -Xms(initial allocation) to avoid heap resizes, Xmx=Xms (G)": 2,4,8
"SQ_JVM_CE memory (Java Heap Size) $YOUR_SONARQUBE_INSTALL_DIR/conf/sonar.properties (sonar.ce.javaOpts) -Xmx(maximum) -Xms(initial allocation) to avoid heap resizes, Xmx=Xms (G)": 2,4,8
"SQ_JVM_Search memory (Java Heap Size) $YOUR_SONARQUBE_INSTALL_DIR/conf/sonar.properties (sonar.search.javaOpts) -Xmx(maximum) -Xms(initial allocation) to avoid heap resizes, Xmx=Xms (G)": 2,4,8
SQ JVM instances/installations (#): 1,1,1
SQ user sessions (#): 1,1,1
SQ CE workers (#): 1,1,1
SQ Cluster/nodes (#): 1,1,1
"SQ_CE (Analyzer 2) yes (1), no (0.9) (coef)": 1,1,1
"Cloud Build_VM with SQ_Scanner/Runner extension (Analyzer 1) "Build Wrapper" RAM (Pay as you go) (G)": 4,8,14
"Cloud Build_VM with SQ_Scanner/Runner extension (Analyzer 1) "Build Wrapper" CPU/Cores (Pay as you go) (#)": 2,4,8
"Cloud Build_VM with SQ_Scanner/Runner extension (Analyzer 1) "Build Wrapper" Temporary Storage (Pay as you go) (#)": 20,40,605
"Cloud Build_VM with SQ_Scanner/Runner extension (Analyzer 1) "Build Wrapper" instance type (Azure specific) (text/note)": A2 v2,A4 v2,A4
"Cloud Build_VM with SQ_Scanner/Runner extension (Analyzer 1) "Build Wrapper" instance price (Pay as you go) AVG per month ($)": 100,200,500
"Cloud Build_VM with SQ_Scanner/Runner extension (Analyzer 1) "Build Wrapper" CPU Cores AVG allocated (%)": 25,25,25
"SQ_Scanner/Runner extension for Cloud Build_VM (Analyzer 1) "Build Wrapper" (Azure DevOps S4NET/S4MSB > MSBuild > .NET Compiler Framework Roslyn analyzer SonarAnalyzer.CSharp) (CONCURRENT EXECUTION) yes (1), no (0.9) (coef)": 1,1,1
"SQ_Scanner/Runner extension for Cloud Build_VM (Analyzer 1) SONAR_SCANNER_OPTS environment variable -Xmx(maximum) -Xms(initial allocation) to avoid heap resizes, Xmx=Xms (G)": 2,4,8
lines of code (LOC): 500000,500000,500000
"Files to be excluded (.editorconfig)(Quality Profile)(%)": 5,5,5
"code complexity (CC) -code logic,project structure (coef)": 0.9,0.9,0.9
"code language/technology .NET/C# (1), Java/Java (0.9) (coef)": 1,1,1
branches (#): 1,1,1
"I/O (RW) disk/data access bandwidth (coef)": 0.9,0.9,0.9
"network bandwidth (coef)": 0.9,0.9,0.9
"language-specific rule-side performance (e.g. a single rule delay), syntax level (StyleCop analyzers),semantic level,symbolic execution,taint analysis (Injection analyzers) (coef)": 0.9,0.9,0.9
"Cloud SQ_DB Cores Server/Serverless(Hyperscale) (Pay as you go) (#)": 2,4,8
"Cloud SQ_DB RAM Server/Serverless(Hyperscale) (Pay as you go) (G)": 4,8,14
"Cloud SQ_DB instance type (Azure specific)(Pay as you go) (text/note)": Gen 5 (Hyperscale),Gen 5 (Hyperscale),Gen 5 (Hyperscale)
"Cloud SQ_DB Temporary Storage Server/Serverless(Hyperscale) (Pay as you go) (G)": 20,20,20
"Cloud SQ_DB instance price Server/Serverless(Hyperscale) (Pay as you go) AVG one hour per day*30 (108000 seconds) ($)": 50,75,100
"system/antivirus logging/monitoring impact (%)": 1.5,1.5,1.5
"Edition/License Free:(1)Community, Commercial:(2)Developer,(3)Enterprise,(4)Data Center": 1,1,1
License cost per # of Instances/Installations + LOC ($):0,0,0
"Predicted/Calculated total cost ($)": 150,275,600
"Predicted/Calculated processing time (min)": 15,7.5,3.75