Must-share information (formatted with Markdown):
- which versions are you using (SonarQube Server / Community Build, Scanner, Plugin, and any relevant extension)
- how is SonarQube deployed: azure on premise
- what are you trying to achieve connect and run a scan
- what have you tried so far to achieve doubling heap size on all processes, increasing the size of the SQL database, also re-indexing the database , increased the number of DTUs to 200. Resetting the database brings everything back to normal as though there is a process holding a lock on the database.
Do not share screenshots of logs – share the text itself (bonus points for being well-formatted)!
Scan times are being reported as taking twice the time as normal. This is causing the pending queue to build up to 30 mins and the subsequent automatic cancellation of Jenkins jobs.On investigation we discovered Data IO was maxing out on the Azure SQL Database. Potentially there is a blocking database process. This is happening on 10.4 version but never occured on 9.9. 502s are returned to jobs attempting to connect to the 10.4 server. We’ve checked the SQL logs and can see a process running at the time of the Data IO max out but we are unable to identify it.
