Task 6.7: Troubleshooting - TraCS Web Service performance issues

Problem Summary

To diagnose TraCS Web Service performance issues it is important to determine where the issue exists. The two most common areas are database indexing or the need for load balancing/additional worker processes.

Solution

Using IIS to monitor web service requests is a good way to narrow down where the performance issue may exist. To do this use the following steps:

• Ensure IIS Request Monitoring is enabled in Windows Features.

Open

• Open IIS Manager

• Open the Main IIS Screen press the Worker Processes button.

  • Then click on ‘Open Feature’ link in upper right, under the ‘Actions’ category.

Open

• Select the TraCS Web Service application pool

Open

• You now have a view of the currently running IIS requests. This is a list of all requests coming from the TraCS Clients (Login, Logout, Search, Form Download, Form Upload, etc.)

Open

• Requests should come in and out of this list often in a production environment with short Time Elapsed entries. The Type= will give what type of request is being sent from the client.

• If Time Elapsed stay short, but the list is growing, it indicates that you need more worker processes or need to setup a load balancer.

• If Time Elapsed is long on items such as Search, then database indexing is likely.