On a web site that is using ASP-DB in 3 tiers for IIS 4, MTS and SQL 7 all on the NT4 operating system.

When the first connection to the web site that uses the ASP-DB MTS component it takes about 30 seconds then when this user uses the same component for a different search it only takes about 3 seconds.

When another user then makes an initial request to the web site it takes
about 10 seconds for the initial request and then about 3 seconds for any
subsequent requests.

Is there a method of finding which of the tiers is taken the most time and
how to reduce this time?