There is a need to identify all the causes that have the potential to impact the performance of applications built upon ASP.Net / Forms / VB etc using oracle 9i at the backend. The user facing clients are thick and not web enabled.
Now, applications apart, consider two offices, main and branch located across 200 kms from each other connected via 10Mb dedicated WAN link provided by our ISP.
The underlying technology of this link is not known but chances are it's MPLS but without CoS aspects.
Application/DB servers are hosted in Main Datacenter from where guys at the branch are also accessing them.
Ping to the servers returns a reply of <1ms from within the Main Site. Over 1500 users are accessing application and generating required reports off this application, just fine.
Over at the branch office, connecting links b/w the two offices, utilisation about a max of 50% at peak times. Ping reply to the app serves hosted at main datacenter return an average of 7ms.
Below is a tracert to a PC lying on branch office from main office:
Tracing route to branchpc.ds.company.local [10.30.1.54]
over a maximum of 30 hops:
1 <1 ms <1 ms <1 ms 10.100.55.2
2 <1 ms <1 ms <1 ms 10.100.10.252
3 15 ms 7 ms 7 ms 172.31.1.2
4 7 ms 8 ms 7 ms 10.30.7.10
5 16 ms 7 ms 13 ms 10.30.1.54
Users from branch are complaining that the app access process is abysmally slow and I have confirmed this.
A report generation process which takes 5 secs at main is taking almost 15 secs at branch.
We cannot host the application/db instance at the branch to improve the performance due to manpower unavailability to maintain and administer the application(s). Access times off all the applications being accessed from branch to main, are coming out to be slow and it's not one application specific.
While the report is being generated, Task Manager in Win XP shows up that particular application associated Task going into a "Not responding" state only to return to the "Running" state after a long delay when the required window/report opens up after about 10-15 secs.
What could be the causes? Where /How should I start investigation?
I understand that internally at main site our client to server communication is happening on a gigabit LAN while at site it's only 10Mpbs dedicated WAN pipe. Would this have an effect? Would this have an effect even while only 50% of it is utilised and their is still sufficent bandwidth left?