Making sure that is_read_committed_snapshot_on is set to true to prevent SonarQube from facing potential deadlocks under heavy loads.Įxample of query to check is_read_committed_snapshot_on: SELECT is_read_committed_snapshot_on FROM sys.databases WHERE name='YourSonarQubeDatabase' Įxample of query to update is_read_committed_snapshot_on: ALTER DATABASE YourSonarQubeDatabase SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK IMMEDIATE Encryption MS SQL database's shared lock strategy may impact SonarQube runtime. READ_COMMITED_SNAPSHOT MUST be set on the SonarQube database. Microsoft SQL ServerĬollation MUST be case-sensitive (CS) and accent-sensitive (AS). Grant this sonarqube user permissions to create, update, and delete objects for this schema. They are real requirements not recommendations.Ĭreate an empty schema and a sonarqube user. Be sure to follow the requirements listed for your database. Several external database engines are supported. The server and database hosts should be located on the same network.Īll hosts must be time-synchronized. One or more scanners running on your build or continuous integration servers to analyze projects.įor optimal performance, the SonarQube server and database should be installed on separate hosts, and the server host should be dedicated. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |