asked 21 Oct '14, 10:22  Rikki |
One Answer:
A screenshot is not really telling the whole story. It looks like the client is opening a lot of connections to a lot of different server ports. I can't tell from the screenshot what they are all used for, but I guess the application is coded to pull a lot of details in separate connections. Maybe my blog post about a similiar setup (using just one connection, but not in a really efficient way either) can shed some light on why the report is slow: http://blog.packet-foo.com/2014/09/how-millisecond-delays-may-kill-database-performance/ My guess is that a lot of small details are pulled one ofter the other, using multiple TCP connections. If so, the only way to improve the situation is to fix the way the report is generated. answered 21 Oct '14, 12:55  Jasper ♦♦ |
i see lot of syn syn-acks when user tries to open a small report (500kb) via SAP. Not sure what this means but the speed that user gets is very very slow