So, I have a page that calls a few different stored procedures along with quite a bit of other ASP stuff related to variable handling and error handling. When it works (the lookup and assignment match nicely) it is a fairly quick process, but when there is a discrepancy it can take 40-200 seconds to return that info and the user has to wait. I am trying to figure out how I track down the bottlenecks in a page like this. Are there any tools out there to help identify execution data for a page like this? It is all ASP with function calls and those functions call stored procedures. Thanks!
WB
WB