This trace related to fetching and generating report hence payload looks bit high and chatty too. It a specific transaction which run and display the report.
Can you just have a look on the same and provide some expert advise. According to me I can see in the trace same sort of queries many times in occurrence for example: MSSQL:BATCH SET FMTONLY ON select BATCH_NUMBER,GL_YEAR,GL_MONTH from JCFJV WHERE 1=2 SET FMTONLY OFF Also server payload bytes linked to all threads very less around 100 bytes. Is there any we can recommend something which can help them reducing app turns 23,550.
Reason for asking you some recommendation because after prediction this 79 seconds increased to 1200 seconds approx. which is scary.
If nothing possible then system need to be local and cannot be migrated over latency of 64 ms.
Answer by Tomasz S. ·
I'm wondering if it's not a similar case to your earlier question? Since the application is accessing the DB server very frequently, even minor latency increase will impact overall performance significantly. This is exactly what RTP is telling you.
The recommendations seem similar - make the application request data from server only when necessary and avoid executing many simple queries. Just my 2 cents :)