Slow Servicedesk

[Firas AlTamimi]

We are experiencing too much slowness in our jira SD hosted server version hosted in our server.

Even we have increased the memory to 5 GB still it is not behaving as expected >browsing is very slow 

We have the following products running integrated with same server

1.SD

2.Software

3.Confluence

Please can someone advise hoe to do the health test for the jira application .It is very urgent

[Firas AlTamimi]

we are unable to migrate data from h2 to postgresql.Do we need a third party tool or xml file migration is suffcient.We are using 

1.Jira SD -2 projects 

2.Jira Software -2 projects 

[Petr Vaníček]

Hi,

can you share more details about your server (memory, count of CPUs, type of drive, DB,...) and application instances (jvm values per app, count of issues in Jira, some huge installed addons,...)?

[Firas AlTamimi]

Thanks peter for your reply

As requested please find below

1.Server 2016 ,Intel (r) Xenon CPU-E5-4667 v3@ 2.00Ghz

2.Virtual Processor -4

3.SSD

4.Application :SD,Software,confluence

5.Database:Internal H2

6.Java memory utilization 5 GB

Looking forward for your response

[Petr Vaníček]

Ohh, as soon as migrate from internal HSQL to normal DBMS (I recommend PostgreSQL) by follow this tutorial. HSQL is only for testing purposes.

https://confluence.atlassian.com/adminjiraserver071/switching-databases-802592192.html#Switchingdatabases-differenttype

This could be one of reasons why it's slow. Let me know when you will have migrated from HSQL to something else.

After that set both apps jvam values XMS and XMX to 2 GB. How many issues you have in Jira?

Then let me know it's better or not. In case of need we will continue.

[Firas AlTamimi]

Dear Peter

I am trying to import activeobjects.xml file in new database postgresql but it is throwing an error message 

Error importing data: org.xml.sax.SAXException: The XML document does not contain the <entity-engine-xml> root element or it was closed too early

Please can you update us 

[Petr Vaníček]

Hi,

did you follow linked tutorial? You should not need manipulate with files inside archive. Just follow tutorial and everything could be ok.