Database Connection URL: Confluence

[Richard]

Hi, have an open ticket with support but responses are very sporadic and therefore I'm just left hanging at moment. 

We have very bad performance of Confluence on our pre-prod server.  I have recently upgraded it from version 6.2 to version 6.13.5 but it hadn't been used in a long time before that, certainly before I worked here at least so I cannot testify to the performance of it before now.   We couldn't even get into the sql instance so refreshed a copy of live db into another instance and I repointed all configs to new db. 

Confluence is painfully slow and I am only user on pre-prod.  I very often get unknown errors when trying to update Apps or accessing System Information (sometimes it gets there mostly it doesn't) and Atlassian said it was due to latency talking to the database.  Both Apps server and db server report healthy performance so I'm struggling to understand where latency is occurring.  There are no firewalls or blocking network issues.

However, looking at System information I notice the latency in pre-prod is high (77) and I noticed it has a stupidly long connection URL compared to Production and I'm suspecting this could be root cause but I do not know where to find/edit this. 

Question? The Confluence.cfg.xml has the string I expect but the System info is obviously reading from somewhere else, database table maybe?

Database connection URL in confluence.cfg.xml

<property name="hibernate.connection.url">jdbc:sqlserver://apc-vd-mssql-01:1433;databaseName=Confluence620_QA</property>

Database connection URL (in full): shown in System Information:-

01:1433;jaasConfigurationName=SQLJDBCDriver;statementPoolingCacheSize=10;serverPreparedStatementDiscardThreshold=10;enablePrepareOnFirstPreparedStatementCall=false;fips=false;socketTimeout=0;authentication=NotSpecified;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustStoreType=JKS;trustServerCertificate=false;TransparentNetworkIPResolution=true;serverNameAsACE=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;queryTimeout=-1;packetSize=8000;multiSubnetFailover=false;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=false;databaseName=Confluence620_QA;columnEncryptionSetting=Disabled;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite;

You can see the database latency and other information in below image

Thank you

Richard

[Gonchik Tsymzhitov · Accepted solution]

Maybe you need to work on latency on dbms side?

https://community.atlassian.com/t5/Data-Center-articles/So-when-we-need-to-adjust-configures-for-RDBMS-Or-DB-Performance/ba-p/1393528