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
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
Hi, Confluence collaborators! As part of #Confluence-Collaboratory month, we’ve created a very special Mythsbusters segment, where we're dive into an interesting myth and uncover the truth behind i...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events