Re: Application Expert-Traffic between Web server and Db server
This situation is really more suited for Application Vantage which uses agents installed on the machine(s) you are going to capture from. I can be done using Application Expert, but there are a few conditions which have to be met.
There are a few ways to accomplish this. First off Application Expert(AE) is meant to be used in a situation where you are either looking only at one tier or where you have all the servers connect to a hub (not a switch) which would allow the machine with AE to see all the traffic.
Connect all the machines (client, web, and db servers) to a hub segmented off from the rest of the network. Setup you filter to include these machines and start the capture. Now just run a single transaction with a single user and you will have your multi-tier capture.
Install AE on the webserver and capture your data from there. When you setup the filter make sure and add the client machine and the db server. This should allow you to capture all the data from both "ends" of the application. I don't see why this would not work, but then again I have never tried it myself.
If you are able to I would go with Option 1. I know that this will work. If you do try option 2, you just need to make sure that you are the only person executing a transaction when you are doing the record. Otherwise, there is a chance that you could get a "corrupted" capture with extra data that could skew your reports.