Microsoft AXDB Slow Performance

Question

There is an issue going on between my application server with microsoft database server.

Basically, my application server is acting as a web server platform for user to generate reports. This application server will be querying data directly from this microsoft database server.

My current issue is that, the web server is taking too much time to generate these reports. In normal scenario, it would take around 5 minutes to generate the report but recently it took almost 20 minutes.

Troubleshooting that I have taken so far:

• Ensure no network connectivity issue between these application server with database server. (no latency & no packet loss)
• Verified there is no I/O performance issue, average latency of 10ms
• Database itself able to query the data in normal speed, no slowness which took around 5 minutes to complete the query. But the application server is taking almost 20 minutes.

From previous observation, normally the time taken for both microsoft database server and application server does not differ much. For example, microsoft database server would take 5 minutes to complete the query and application server would take 6 minutes to finish generating the report.

NOTE : This issue happens after I virtualized my microsoft database server from physical state through P2V. There shall not be performance bottleneck when comes to CPU/memory because it has been allocated more in the virtual environment. On storage wise, it has a hybrid setup of SSD & SAS. The overall IO latency with some VM running in the same platform is 50~100ms.

Anyone has came across such issue?